using System;
using System.Diagnostics;
using System.Text;

using i64 = System.Int64;
using u32 = System.UInt32;
namespace Community.CsharpSqlite
{
#if TCLSH
  using tcl.lang;
  using ClientData = System.Object;
  using sqlite3_int64 = System.Int64;
  using sqlite3_stmt = Sqlite3.Vdbe;
  using sqlite3_u3264 = System.UInt64;
  using sqlite3_value = Sqlite3.Mem;
  using Tcl_Interp = tcl.lang.Interp;
  using Tcl_Obj = tcl.lang.TclObject;

  public partial class Sqlite3
  {
    /*
    ** 2001 September 15
    **
    ** The author disclaims copyright to this source code. In place of
    ** a legal notice, here is a blessing:
    **
    ** May you do good and not evil.
    ** May you find forgiveness for yourself and forgive others.
    ** May you share freely, never taking more than you give.
    **
    *************************************************************************
    ** Code for testing all sorts of SQLite interfaces. This code
    ** is not included in the SQLite library. It is used for automated
    ** testing of the SQLite library.
    *************************************************************************
    ** Included in SQLite3 port to C#-SQLite; 2008 Noah B Hart
    ** C#-SQLite is an independent reimplementation of the SQLite software library
    **
    ** SQLITE_SOURCE_ID: 2011-06-23 19:49:22 4374b7e83ea0a3fbc3691f9c0c936272862f32f2
    **
    *************************************************************************
    */
    //#include "sqliteInt.h"
    //#include "tcl.h"
    //#include <stdlib.h>
    //#include <string.h>

    /*
    ** This is a copy of the first part of the SqliteDb structure in
    ** tclsqlite.c. We need it here so that the get_sqlite_pointer routine
    ** can extract the sqlite3* pointer from an existing Tcl SQLite
    ** connection.
    */
    //struct SqliteDb {
    // sqlite3 db=null;
    //};

    /*
    ** Convert text generated by the "%p" conversion format back into
    ** a pointer.
    */
    static int testHexToInt( int h )
    {
      if ( h >= '0' && h <= '9' )
      {
        return h - '0';
      }
      else if ( h >= 'a' && h <= 'f' )
      {
        return h - 'a' + 10;
      }
      else
      {
        Debug.Assert( h >= 'A' && h <= 'F' );
        return h - 'A' + 10;
      }
    }
    static object sqlite3TestTextToPtr( Tcl_Interp interp, string z )
    {
      //object p ;
      //var v = new u64[1];
      //u32 v2;
      //int zIndex = 0;
      //if ( z[0] == '0' && z[1] == 'x' )
      //{
      // zIndex += 2;
      //}
      //v[0] = 0;
      //while ( zIndex < z.Length )* z )
      //{
      // v[0] = ( v[0] << 4 ) + (ulong)testHexToInt( z[zIndex] );
      // zIndex++;
      //}
      //if ( sizeof( object ) == sizeof( u64 ) )
      //{
      // Marshal.Copy( v, 0, (IntPtr)p, 1 );// memcpy( &p, v, sizeof( p ) );
      //}
      //else
      //{
      // Debug.Assert( sizeof( p ) == sizeof( v2 ) );
      // v2 = (u32)v;
      // memcpy( &p, v2, sizeof( p ) );
      //}
      WrappedCommand cmdInfo = new WrappedCommand();
      if ( TCL.Tcl_GetCommandInfo( interp, z, out cmdInfo ) || cmdInfo == null )
      {
        return null;
      }
      else
      {
        return cmdInfo.objClientData;
      }
    }


    /*
    ** A TCL command that returns the address of the sqlite* pointer
    ** for an sqlite connection instance. Bad things happen if the
    ** input is not an sqlite connection.
    */
    static int get_sqlite_pointer(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      SqliteDb p;
      WrappedCommand cmdInfo = null;
      //string zBuf ;//[100];
      if ( objc != 2 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "SQLITE-CONNECTION" );
        return TCL.TCL_ERROR;
      }
      if ( TCL.Tcl_GetCommandInfo( interp, objv[1].ToString(), out cmdInfo ) )
      {
        TCL.Tcl_AppendResult( interp, "command not found: ",
        TCL.Tcl_GetString( objv[1] ), null );
        return TCL.TCL_ERROR;
      }
      //p = (SqliteDb)cmdInfo.objclientdata;
      //zBuf = p.db.GetHashCode().ToString();
      //sqlite3_snprintf( zBuf, "%p", p.db );
      //if( strncmp(zBuf,"0x",2) ){
      // sqlite3_snprintf(zBuf, "0x%p", p.db);
      //}
      //TCL.Tcl_AppendResult(interp, zBuf,null );
      TCL.Tcl_AppendResult( interp, objv[1].ToString() );
      return TCL.TCL_OK;
    }

    /*
    ** Decode a pointer to an sqlite3 object.
    */
    static int getDbPointer( Tcl_Interp interp, string zA, out sqlite3 ppDb )
    {
      SqliteDb p;
      WrappedCommand cmdInfo = new WrappedCommand();
      if ( !TCL.Tcl_GetCommandInfo( interp, zA, out cmdInfo ) )
      {
        if ( cmdInfo == null )
        {
          ppDb = new sqlite3();
        }
        else
        {
          p = (SqliteDb)cmdInfo.objClientData;
          ppDb = p.db;
        }
      }
      else
      {
        ppDb = null;
      }
      return TCL.TCL_OK;
    }


    static string sqlite3TestErrorName( int rc )
    {
      string zName = "";
      switch ( rc )
      {
        case SQLITE_OK:
          zName = "SQLITE_OK";
          break;
        case SQLITE_ERROR:
          zName = "SQLITE_ERROR";
          break;
        case SQLITE_INTERNAL:
          zName = "SQLITE_INTERNAL";
          break;
        case SQLITE_PERM:
          zName = "SQLITE_PERM";
          break;
        case SQLITE_ABORT:
          zName = "SQLITE_ABORT";
          break;
        case SQLITE_BUSY:
          zName = "SQLITE_BUSY";
          break;
        case SQLITE_LOCKED:
          zName = "SQLITE_LOCKED";
          break;
        case SQLITE_LOCKED_SHAREDCACHE:
          zName = "SQLITE_LOCKED_SHAREDCACHE";
          break;
        case SQLITE_NOMEM:
          zName = "SQLITE_NOMEM";
          break;
        case SQLITE_READONLY:
          zName = "SQLITE_READONLY";
          break;
        case SQLITE_INTERRUPT:
          zName = "SQLITE_INTERRUPT";
          break;
        case SQLITE_IOERR:
          zName = "SQLITE_IOERR";
          break;
        case SQLITE_CORRUPT:
          zName = "SQLITE_CORRUPT";
          break;
        case SQLITE_NOTFOUND:
          zName = "SQLITE_NOTFOUND";
          break;
        case SQLITE_FULL:
          zName = "SQLITE_FULL";
          break;
        case SQLITE_CANTOPEN:
          zName = "SQLITE_CANTOPEN";
          break;
        case SQLITE_PROTOCOL:
          zName = "SQLITE_PROTOCOL";
          break;
        case SQLITE_EMPTY:
          zName = "SQLITE_EMPTY";
          break;
        case SQLITE_SCHEMA:
          zName = "SQLITE_SCHEMA";
          break;
        case SQLITE_TOOBIG:
          zName = "SQLITE_TOOBIG";
          break;
        case SQLITE_CONSTRAINT:
          zName = "SQLITE_CONSTRAINT";
          break;
        case SQLITE_MISMATCH:
          zName = "SQLITE_MISMATCH";
          break;
        case SQLITE_MISUSE:
          zName = "SQLITE_MISUSE";
          break;
        case SQLITE_NOLFS:
          zName = "SQLITE_NOLFS";
          break;
        case SQLITE_AUTH:
          zName = "SQLITE_AUTH";
          break;
        case SQLITE_FORMAT:
          zName = "SQLITE_FORMAT";
          break;
        case SQLITE_RANGE:
          zName = "SQLITE_RANGE";
          break;
        case SQLITE_NOTADB:
          zName = "SQLITE_NOTADB";
          break;
        case SQLITE_ROW:
          zName = "SQLITE_ROW";
          break;
        case SQLITE_DONE:
          zName = "SQLITE_DONE";
          break;
        case SQLITE_IOERR_READ:
          zName = "SQLITE_IOERR_READ";
          break;
        case SQLITE_IOERR_SHORT_READ:
          zName = "SQLITE_IOERR_SHORT_READ";
          break;
        case SQLITE_IOERR_WRITE:
          zName = "SQLITE_IOERR_WRITE";
          break;
        case SQLITE_IOERR_FSYNC:
          zName = "SQLITE_IOERR_FSYNC";
          break;
        case SQLITE_IOERR_DIR_FSYNC:
          zName = "SQLITE_IOERR_DIR_FSYNC";
          break;
        case SQLITE_IOERR_TRUNCATE:
          zName = "SQLITE_IOERR_TRUNCATE";
          break;
        case SQLITE_IOERR_FSTAT:
          zName = "SQLITE_IOERR_FSTAT";
          break;
        case SQLITE_IOERR_UNLOCK:
          zName = "SQLITE_IOERR_UNLOCK";
          break;
        case SQLITE_IOERR_RDLOCK:
          zName = "SQLITE_IOERR_RDLOCK";
          break;
        case SQLITE_IOERR_DELETE:
          zName = "SQLITE_IOERR_DELETE";
          break;
        case SQLITE_IOERR_BLOCKED:
          zName = "SQLITE_IOERR_BLOCKED";
          break;
        case SQLITE_IOERR_NOMEM:
          zName = "SQLITE_IOERR_NOMEM";
          break;
        case SQLITE_IOERR_ACCESS:
          zName = "SQLITE_IOERR_ACCESS";
          break;
        case SQLITE_IOERR_CHECKRESERVEDLOCK:
          zName = "SQLITE_IOERR_CHECKRESERVEDLOCK";
          break;
        case SQLITE_IOERR_LOCK:
          zName = "SQLITE_IOERR_LOCK";
          break;
        case SQLITE_CORRUPT_VTAB:
          zName = "SQLITE_CORRUPT_VTAB";
          break;
        case SQLITE_READONLY_RECOVERY:
          zName = "SQLITE_READONLY_RECOVERY";
          break;
        case SQLITE_READONLY_CANTLOCK:
          zName = "SQLITE_READONLY_CANTLOCK";
          break;
        default:
          zName = "SQLITE_Unknown";
          break;
      }
      return zName;
    }
    //#define t1ErrorName sqlite3TestErrorName
    static string t1ErrorName( int i )
    {
      return sqlite3TestErrorName( i );
    }
    /*
    ** Convert an sqlite3_stmt* into an sqlite3*. This depends on the
    ** fact that the sqlite3* is the first field in the Vdbe structure.
    */
    //#define StmtToDb(X) sqlite3_db_handle(X)
    static sqlite3 StmtToDb( Vdbe v )
    {
      return sqlite3_db_handle( v );
    }

    /*
    ** Check a return value to make sure it agrees with the results
    ** from sqlite3_errcode.
    */
    static int sqlite3TestErrCode( Tcl_Interp interp, sqlite3 db, int rc )
    {
      if ( sqlite3_threadsafe() == 0 && rc != SQLITE_MISUSE && rc != SQLITE_OK
      && sqlite3_errcode( db ) != rc )
      {
        StringBuilder zBuf = new StringBuilder( 200 );//char zBuf[200];
        int r2 = sqlite3_errcode( db );
        sqlite3_snprintf( 200, zBuf, "error code %s (%d) does not match sqlite3_errcode %s (%d)",
        sqlite3TestErrorName( rc ), rc, sqlite3TestErrorName( r2 ), r2 );//t1ErrorName( rc ), rc, t1ErrorName( r2 ), r2 );
        TCL.Tcl_ResetResult( interp );
        TCL.Tcl_AppendResult( interp, zBuf.ToString() );
        return 1;
      }
      return 0;
    }

    /*
    ** Decode a pointer to an sqlite3_stmt object.
    */
    static int getStmtPointer(
    Tcl_Interp interp,
    string zArg,
    out sqlite3_stmt ppStmt
    )
    {
      ppStmt = (sqlite3_stmt)sqlite3TestTextToPtr( interp, zArg );
      WrappedCommand cmdInfo = new WrappedCommand();
      TCL.Tcl_GetCommandInfo( interp, zArg, out cmdInfo );
      ppStmt = cmdInfo == null ? null : (sqlite3_stmt)cmdInfo.objClientData;

      return TCL.TCL_OK;
    }

    /*
    ** Generate a text representation of a pointer that can be understood
    ** by the getDbPointer and getVmPointer routines above.
    **
    ** The problem is, on some machines (Solaris) if you do a printf with
    ** "%p" you cannot turn around and do a scanf with the same "%p" and
    ** get your pointer back. You have to prepend a "0x" before it will
    ** work. Or at least that is what is reported to me (drh). But this
    ** behavior varies from machine to machine. The solution used her is
    ** to test the string right after it is generated to see if it can be
    ** understood by scanf, and if not, try prepending an "0x" to see if
    ** that helps. If nothing works, a fatal error is generated.
    */
    /*
    ** Decode a pointer to an sqlite3_stmt object.
    */


    static int sqlite3TestMakePointerStr( Tcl_Interp interp, StringBuilder zPtr, object p )
    {
      sqlite3_snprintf( 100, zPtr, "->%p", p );
      if ( TCL.Tcl_CreateCommandPointer( interp, zPtr, p ) )
      {
        return TCL.TCL_ERROR;
      }
      return TCL.TCL_OK;
    }

    /*
    ** The callback routine for sqlite3_exec_printf().
    */
    static int exec_printf_cb( object pArg, sqlite3_int64 argc, object p2, object p3 )
    {
      string[] name = (string[])p3;
      string[] argv = (string[])p2;
      TclObject str = (TclObject)pArg;
      int i;

      if ( TCL.Tcl_DStringLength( str ) == 0 )
      {
        for ( i = 0; i < argc; i++ )
        {
          TCL.Tcl_DStringAppendElement( str, name[i] != null ? name[i] + " " : "NULL " );
        }
      }
      string beginbrace = "", endbrace = "";
      for ( i = 0; i < argc; i++ )
      {
        if ( argc > 1 )
        {
          if ( Util.scanElement( null, argv[i].ToString() ) != 0 )
          {
            beginbrace = "{";
            endbrace = "}";
          }
          else
          {
            beginbrace = "";
            endbrace = "";
          }
        }
        TCL.Tcl_DStringAppendElement( str, argv[i] != null ? beginbrace + argv[i] + endbrace + ( i < argc - 1 ? " " : "" ) : "NULL" );
      }
      return 0;
    }

    /*
    ** The I/O tracing callback.
    */
#if !(SQLITE_OMIT_TRACE) && TRACE
//static FILE *iotrace_file = 0;
//static void io_trace_callback(string zFormat, ...){
// va_list ap;
// va_start(ap, zFormat);
// vfprintf(iotrace_file, zFormat, ap);
// va_end(ap);
// fflush(iotrace_file);
//}
#endif

    /*
** Usage: io_trace FILENAME
**
** Turn I/O tracing on or off. If FILENAME is not an empty string,
** I/O tracing begins going into FILENAME. If FILENAME is an empty
** string, I/O tracing is turned off.
*/
    //static int test_io_trace(
    // object NotUsed,
    // Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    // int argc, /* Number of arguments */
    // Tcl_Obj[] argv /* Text of each argument */
    //){
#if !(SQLITE_OMIT_TRACE) && (TRACE)
// if( argc!=2 ){
// TCL.Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
// " FILENAME\"", 0);
// return TCL.TCL_ERROR;
// }
// if( iotrace_file ){
// if( iotrace_file!=stdout && iotrace_file!=stderr ){
// fclose(iotrace_file);
// }
// iotrace_file = 0;
// sqlite3IoTrace = 0;
// }
// if( argv[1][0] ){
// if( strcmp(argv[1],"stdout")==0 ){
// iotrace_file = stdout;
// }else if( strcmp(argv[1],"stderr")==0 ){
// iotrace_file = stderr;
// }else{
// iotrace_file = fopen(argv[1], "w");
// }
// sqlite3IoTrace = io_trace_callback;
// }
#endif
    // return TCL.TCL_OK;
    //}


    /*
    ** Usage: sqlite3_exec_printf DB FORMAT STRING
    **
    ** Invoke the sqlite3_exec_printf() interface using the open database
    ** DB. The SQL is the string FORMAT. The format string should contain
    ** one %s or %q. STRING is the value inserted into %s or %q.
    */
    static int test_exec_printf(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      sqlite3 db = null;
      TclObject str = null;
      int rc;
      string zErr = "";
      string zSql = "";
      StringBuilder zBuf = new StringBuilder( 30 );
      if ( argc != 4 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " DB FORMAT STRING" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      TCL.Tcl_DStringInit( out str );
      zSql = sqlite3_mprintf( argv[2].ToString(), argv[3].ToString() );
      rc = sqlite3_exec( db, zSql, (dxCallback)exec_printf_cb, str, ref zErr );
      sqlite3DbFree( db, ref zSql );
      sqlite3_snprintf( 30, zBuf, "%d", rc );
      TCL.Tcl_AppendElement( interp, zBuf );
      TCL.Tcl_AppendElement( interp, rc == SQLITE_OK ? str.ToString() : zErr ); //TCL.Tcl_DStringValue(ref str)
      TCL.Tcl_DStringFree( ref str );
      if ( zErr != null )
        sqlite3DbFree( db, ref zErr );
      if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
        return TCL.TCL_ERROR;
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_exec_hex DB HEX
    **
    ** Invoke the sqlite3_exec() on a string that is obtained by translating
    ** HEX into ASCII. Most characters are translated as is. %HH becomes
    ** a hex character.
    */
    static int test_exec_hex(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      sqlite3 db = null;
      TclObject str = null;
      int rc, i, j;
      string zErr = "";
      string zHex;
      StringBuilder zSql = new StringBuilder( 500 );
      string zBuf = "";
      if ( argc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " DB HEX" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      zHex = argv[2].ToString();
      for ( i = j = 0; j < zHex.Length && zHex[j] != 0; i++, j++ )
      {
        if ( zHex[j] == '%' && zHex[j + 2] != 0 && zHex[j + 2] != 0 )
        {
          zSql.Append( (char)( ( testHexToInt( zHex[j + 1] ) << 4 ) + testHexToInt( zHex[j + 2] ) ) );
          j += 2;
        }
        else
        {
          zSql.Append( zHex[j] );
        }
      }
      //zSql[i] = '\0';
      TCL.Tcl_DStringInit( out str );
      rc = sqlite3_exec( db, zSql.ToString(), (dxCallback)exec_printf_cb, str, ref zErr );
      zBuf = rc.ToString();// sprintf( zBuf, "%d", rc );
      TCL.Tcl_AppendElement( interp, zBuf );
      TCL.Tcl_AppendElement( interp, rc == SQLITE_OK ? str.ToString() : zErr );
      TCL.Tcl_DStringFree( ref str );
      // //sqlite3_free(ref zErr);
      if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
        return TCL.TCL_ERROR;
      return TCL.TCL_OK;
    }


    /*
    ** Usage: db_enter DB
    ** db_leave DB
    **
    ** Enter or leave the mutex on a database connection.
    */
    static int db_enter(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      sqlite3 db = null;
      if ( argc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " DB" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      sqlite3_mutex_enter( db.mutex );
      return TCL.TCL_OK;
    }
    static int db_leave(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      sqlite3 db = null;
      if ( argc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " DB" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      sqlite3_mutex_leave( db.mutex );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_exec DB SQL
    **
    ** Invoke the sqlite3_exec interface using the open database DB
    */
    static int test_exec(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      sqlite3 db = null;
      TclObject str = TclString.newInstance( "" );
      int rc;
      string zErr = "";
      string zSql;
      int i, j;
      StringBuilder zBuf = new StringBuilder( 30 );
      if ( argc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " DB SQL" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      TCL.Tcl_DStringInit( out str );
      zSql = sqlite3_mprintf( "%s", argv[2].ToString() );
      StringBuilder sb = new StringBuilder( zSql.Length );
      for ( i = 0; i < zSql.Length; i++ )
      {
        if ( zSql[i] == '%' )
        {
          sb.Append( (char)( ( testHexToInt( zSql[i + 1] ) << 4 ) + testHexToInt( zSql[i + 2] ) ) );
          i += 2;
        }
        else
          sb.Append( zSql[i] );
      }
      ////zSql[j] = 0;
      rc = sqlite3_exec( db, sb.ToString(), exec_printf_cb, str, ref zErr );
      sqlite3DbFree( db, ref zSql );
      sqlite3_snprintf( 30, zBuf, "%d", rc );
      TCL.Tcl_AppendElement( interp, zBuf );
      TCL.Tcl_AppendElement( interp, rc == SQLITE_OK ? str.ToString() : zErr );
      //TCL.Tcl_DStringFree(&str);
      if ( zErr != "" )
        sqlite3DbFree( db, ref zErr );
      if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
        return TCL.TCL_ERROR;
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_exec_nr DB SQL
    **
    ** Invoke the sqlite3_exec interface using the open database DB. Discard
    ** all results
    */
    static int test_exec_nr(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      sqlite3 db = null;
      int rc;
      string zErr = "";
      if ( argc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " DB SQL" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      rc = sqlite3_exec( db, argv[2].ToString(), null, null, ref zErr );
      if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
        return TCL.TCL_ERROR;
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_mprintf_z_test SEPARATOR ARG0 ARG1 ...
    **
    ** Test the %z format of sqlite_mprintf(). Use multiple mprintf() calls to
    ** concatenate arg0 through argn using separator as the separator.
    ** Return the result.
    */
    static int test_mprintf_z(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      string zResult = "";
      int i;

      for ( i = 2; i < argc && ( i == 2 || zResult != "" ); i++ )
      {
        zResult = sqlite3_mprintf( "%z%s%s", zResult, argv[1].ToString(), argv[i].ToString() );
      }
      TCL.Tcl_AppendResult( interp, zResult );
      //sqlite3DbFree( db, zResult );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_mprintf_n_test STRING
    **
    ** Test the %n format of sqlite_mprintf(). Return the length of the
    ** input string.
    */
    static int test_mprintf_n(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      string zStr;
      int n = 0;
      zStr = sqlite3_mprintf( "%s%n", argv[1].ToString() );
      n = zStr.Length;
      //sqlite3DbFree( db, zStr );
      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( n ) );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_snprintf_int SIZE FORMAT INT
    **
    ** Test the of sqlite3_snprintf() routine. SIZE is the size of the
    ** output buffer in bytes. The maximum size is 100. FORMAT is the
    ** format string. INT is a single integer argument. The FORMAT
    ** string must require no more than this one integer argument. If
    ** You pass in a format string that requires more than one argument,
    ** bad things will happen.
    */
    static int test_snprintf_int(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      StringBuilder zStr = new StringBuilder( 100 );
      int n = atoi( argv[1].ToString() );
      string zFormat = argv[2].ToString();
      int a1 = atoi( argv[3].ToString() );
      if ( n > zStr.Capacity )
        n = zStr.Capacity;// sizeof( zStr );
      zStr = new StringBuilder( "abcdefghijklmnopqrstuvwxyz" );
      sqlite3_snprintf( n, zStr, zFormat, a1 );
      TCL.Tcl_AppendResult( interp, zStr );
      return TCL.TCL_OK;
    }

#if !SQLITE_OMIT_GET_TABLE
/*
** Usage: sqlite3_get_table_printf DB FORMAT STRING ?--no-counts?
**
** Invoke the sqlite3_get_table_printf() interface using the open database
** DB. The SQL is the string FORMAT. The format string should contain
** one %s or %q. STRING is the value inserted into %s or %q.
*/
static int test_get_table_printf(
object NotUsed,
Tcl_Interp interp, /* The TCL interpreter that invoked this command */
int argc, /* Number of arguments */
Tcl_Obj[] argv /* Text of each argument */
){
sqlite3 db=null;
TCL.Tcl_DString str;
int rc;
string zErr = 0;
int nRow, nCol;
char **aResult;
int i;
char zBuf[30];
string zSql;
int resCount = -1;
if( argc==5 ){
if( TCL.Tcl_GetInt(interp, argv[4], out resCount) ) return TCL.TCL_ERROR;
}
if( argc!=4 && argc!=5 ){
TCL.Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
" DB FORMAT STRING ?COUNT?", 0);
return TCL.TCL_ERROR;
}
if( getDbPointer(interp, argv[1].ToString(), out db) !=0) return TCL.TCL_ERROR;
TCL.Tcl_DStringInit(&str);
zSql = sqlite3_mprintf(argv[2],argv[3]);
if( argc==5 ){
rc = sqlite3_get_table(db, zSql, aResult, 0, 0, zErr);
}else{
rc = sqlite3_get_table(db, zSql, aResult, nRow, nCol, zErr);
resCount = (nRow+1)*nCol;
}
sqlite3DbFree(db,zSql);
sqlite3_snprintf(zBuf, "%d", rc);
TCL.Tcl_AppendElement(interp, zBuf);
if( rc==SQLITE_OK ){
if( argc==4 ){
sqlite3_snprintf(zBuf, "%d", nRow);
TCL.Tcl_AppendElement(interp, zBuf);
sqlite3_snprintf(zBuf, "%d", nCol);
TCL.Tcl_AppendElement(interp, zBuf);
}
for(i=0; i<resCount; i++){
TCL.Tcl_AppendElement(interp, aResult[i] ? aResult[i] : "NULL");
}
}else{
TCL.Tcl_AppendElement(interp, zErr);
}
//sqlite3_free_table(aResult);
if( zErr ) sqlite3DbFree(db,zErr);
if( sqlite3TestErrCode(interp, db, rc) ) return TCL.TCL_ERROR;
return TCL.TCL_OK;
}
#endif //* SQLITE_OMIT_GET_TABLE*/

    /*
** Usage: sqlite3_last_insert_rowid DB
**
** Returns the integer ROWID of the most recent insert.
*/
    //static int test_last_rowid(
    // object NotUsed,
    // Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    // int argc, /* Number of arguments */
    // Tcl_Obj[] argv /* Text of each argument */
    //){
    // sqlite3 db=null;
    // char zBuf[30];

    // if( argc!=2 ){
    // TCL.Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], " DB\"");
    // return TCL.TCL_ERROR;
    // }
    // if( getDbPointer(interp, argv[1].ToString(), out db) !=0) return TCL.TCL_ERROR;
    // sqlite3_snprintf(zBuf, "%lld", sqlite3_last_insert_rowid(db));
    // TCL.Tcl_AppendResult(interp, zBuf);
    // return SQLITE_OK;
    //}

    /*
    ** Usage: sqlite3_key DB KEY
    **
    ** Set the codec key.
    */
    static int test_key(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      sqlite3 db = null;
      string zKey;
      int nKey;
      if ( argc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " FILENAME\"" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      zKey = argv[2].ToString();
      nKey = zKey.Length;
#if SQLITE_HAS_CODEC
      sqlite3_key( db, zKey, nKey );
#endif
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_rekey DB KEY
    **
    ** Change the codec key.
    */
    static int test_rekey(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      sqlite3 db = null;
      string zKey;
      int nKey;
      if ( argc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " FILENAME\"" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      zKey = argv[2].ToString();
      nKey = zKey.Length;
#if SQLITE_HAS_CODEC
      sqlite3_rekey( db, zKey, nKey );
#endif
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_close DB
    **
    ** Closes the database opened by sqlite3_open.
    */
    static int sqlite_test_close(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      sqlite3 db = null;
      int rc;
      if ( argc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " FILENAME\"" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      rc = sqlite3_close( db );
      TCL.Tcl_SetResult( interp, t1ErrorName( rc ), TCL.TCL_STATIC );
      return TCL.TCL_OK;
    }

    /*
    ** Implementation of the x_coalesce() function.
    ** Return the first argument non-NULL argument.
    */
    static void t1_ifnullFunc(
    sqlite3_context context,
    int argc,
    sqlite3_value[] argv
    )
    {
      int i;
      for ( i = 0; i < argc; i++ )
      {
        if ( SQLITE_NULL != sqlite3_value_type( argv[i] ) )
        {
          int n = sqlite3_value_bytes( argv[i] );
          sqlite3_result_text( context, sqlite3_value_text( argv[i] ),
          n, SQLITE_TRANSIENT );
          break;
        }
      }
    }

    /*
    ** These are test functions. hex8() interprets its argument as
    ** UTF8 and returns a hex encoding. hex16le() interprets its argument
    ** as UTF16le and returns a hex encoding.
    */
    static void hex8Func( sqlite3_context p, int argc, sqlite3_value[] argv )
    {
      string z;
      int i;
      StringBuilder zBuf = new StringBuilder( 200 );
      z = sqlite3_value_text( argv[0] );
      StringBuilder zTemp = new StringBuilder( 200 );
      for ( i = 0; i < zBuf.Capacity / 2 - 2 && i < argv[0].n; i++ )
      {
        sqlite3_snprintf( 4, zTemp, "%02x", z[i] & 0xff );
        zBuf.Append( zTemp );
      }
      //zBuf[i*2] = 0;
      sqlite3_result_text( p, zBuf, -1, SQLITE_TRANSIENT );
    }
#if !SQLITE_OMIT_UTF16
static void hex16Func(sqlite3_context p, int argc, sqlite3_value[] argv){
Debugger.Break (); //TODO --
// const unsigned short int *z;
// int i;
// char zBuf[400];
// z = sqlite3_value_text16(argv[0]);
// for(i=0; i<sizeof(zBuf)/4 - 4 && z[i]; i++){
// sqlite3_snprintf(&zBuf[i*4], "%04x", z[i]&0xff);
// }
// zBuf[i*4] = 0;
// sqlite3_result_text(p, (char)zBuf, -1, SQLITE_TRANSIENT);
}
#endif

    /*
** A structure into which to accumulate text.
*/
    struct dstr
    {
      public int nAlloc; /* Space allocated */
      public int nUsed; /* Space used */
      public StringBuilder z; /* The space */
    };

    /*
    ** Append text to a dstr
    */
    static void dstrAppend( dstr p, string z, int divider )
    {
      int n = z.Length;// strlen( z );
      // if( p.nUsed + n + 2 > p.nAlloc ){
      // string zNew;
      p.nAlloc = p.nAlloc * 2 + n + 200;
      p.z.Capacity = p.nAlloc;
      // zNew = sqlite3_realloc(p.z, p.nAlloc);
      // if( zNew==0 ){
      // sqlite3DbFree(db,p.z);
      // memset(p, 0, sizeof(*p));
      // return;
      // }
      // p.z = zNew;
      // }
      // if( divider && p.nUsed>0 ){
      // p.z[p.nUsed++] = divider;
      // }
      // memcpy(p.z[p.nUsed], z, n+1);
      p.nUsed += n;
      p.z.Append( divider + z );
    }

    /*
    ** Invoked for each callback from sqlite3ExecFunc
    */
    static int execFuncCallback( object pData, sqlite3_int64 argc, object _argv, object NotUsed )
    {
      Tcl_Obj[] argv = (Tcl_Obj[])_argv;
      dstr p = (dstr)pData;
      int i;
      for ( i = 0; i < argc; i++ )
      {
        if ( argv[i] == null )
        {
          dstrAppend( p, "NULL", ' ' );
        }
        else
        {
          dstrAppend( p, argv[i].ToString(), ' ' );
        }
      }
      return 0;
    }

    /*
    ** Implementation of the x_sqlite_exec() function. This function takes
    ** a single argument and attempts to execute that argument as SQL code.
    ** This is illegal and should set the SQLITE_MISUSE flag on the database.
    **
    ** 2004-Jan-07: We have changed this to make it legal to call sqlite3_exec()
    ** from within a function call.
    **
    ** This routine simulates the effect of having two threads attempt to
    ** use the same database at the same time.
    */
    static void sqlite3ExecFunc(
    sqlite3_context context,
    int argc,
    sqlite3_value[] argv
    )
    {
      dstr x = new dstr();
      //memset(&x, 0, sizeof(x));
      string sDummy = "";
      sqlite3_exec( (sqlite3)sqlite3_context_db_handle( context ),
      sqlite3_value_text( argv[0] ),
      (dxCallback)execFuncCallback, (object)x, ref sDummy );
      sqlite3_result_text( context, x.z, x.nUsed, SQLITE_TRANSIENT );
      x.z = null;// sqlite3DbFree( db, ref x.z );
    }

    /*
    ** Implementation of tkt2213func(), a scalar function that takes exactly
    ** one argument. It has two interesting features:
    **
    ** * It calls sqlite3_value_text() 3 times on the argument sqlite3_value*.
    ** If the three pointers returned are not the same an SQL error is raised.
    **
    ** * Otherwise it returns a copy of the text representation of its
    ** argument in such a way as the VDBE representation is a Mem* cell
    ** with the MEM_Term flag clear.
    **
    ** Ticket #2213 can therefore be tested by evaluating the following
    ** SQL expression:
    **
    ** tkt2213func(tkt2213func('a string'));
    */
    static void tkt2213Function(
    sqlite3_context context,
    int argc,
    sqlite3_value[] argv
    )
    {
      int nText;
      string zText1;
      string zText2;
      string zText3;

      nText = sqlite3_value_bytes( argv[0] );
      zText1 = sqlite3_value_text( argv[0] );
      zText2 = sqlite3_value_text( argv[0] );
      zText3 = sqlite3_value_text( argv[0] );

      if ( zText1 != zText2 || zText2 != zText3 )
      {
        sqlite3_result_error( context, "tkt2213 is not fixed", -1 );
      }
      else
      {
        //string zCopy = (char )sqlite3Malloc(nText);
        //memcpy(zCopy, zText1, nText);
        sqlite3_result_text( context, zText1, nText, null ); //sqlite3_free );
      }
    }

    /*
    ** The following SQL function takes 4 arguments. The 2nd and
    ** 4th argument must be one of these strings: 'text', 'text16',
    ** or 'blob' corresponding to API functions
    **
    ** sqlite3_value_text()
    ** sqlite3_value_text16()
    ** sqlite3_value_blob()
    **
    ** The third argument is a string, either 'bytes' or 'bytes16' or 'noop',
    ** corresponding to APIs:
    **
    ** sqlite3_value_bytes()
    ** sqlite3_value_bytes16()
    ** noop
    **
    ** The APIs designated by the 2nd through 4th arguments are applied
    ** to the first argument in order. If the pointers returned by the
    ** second and fourth are different, this routine returns 1. Otherwise,
    ** this routine returns 0.
    **
    ** This function is used to test to see when returned pointers from
    ** the _text(), _text16() and _blob() APIs become invalidated.
    */
    static void ptrChngFunction(
    sqlite3_context context,
    int argc,
    sqlite3_value[] argv
    )
    {
      sqlite3_result_int( context, 0 );
      return;
      //Debugger.Break(); //TODO --
      //string p1 = "", p2 = "";
      //string zCmd;
      //if ( argc != 4 )
      //  return;
      //zCmd = sqlite3_value_text( argv[1] );
      //if ( zCmd == null )
      //  return;
      // if( strcmp(zCmd,"text")==0 ){
      // p1 = (const void)sqlite3_value_text(argv[0]);
      //#if !SQLITE_OMIT_UTF16
      // }else if( strcmp(zCmd, "text16")==0 ){
      // p1 = (const void)sqlite3_value_text16(argv[0]);
      //#endif
      // }else if( strcmp(zCmd, "blob")==0 ){
      // p1 = (const void)sqlite3_value_blob(argv[0]);
      // }else{
      // return;
      // }
      // zCmd = (const char)sqlite3_value_text(argv[2]);
      // if( zCmd==0 ) return;
      // if( strcmp(zCmd,"bytes")==0 ){
      // sqlite3_value_bytes(argv[0]);
      //#if !SQLITE_OMIT_UTF16
      // }else if( strcmp(zCmd, "bytes16")==0 ){
      // sqlite3_value_bytes16(argv[0]);
      //#endif
      // }else if( strcmp(zCmd, "noop")==0 ){
      // /* do nothing */
      // }else{
      // return;
      // }
      // zCmd = (const char)sqlite3_value_text(argv[3]);
      // if( zCmd==0 ) return;
      // if( strcmp(zCmd,"text")==0 ){
      // p2 = (const void)sqlite3_value_text(argv[0]);
      //#if !SQLITE_OMIT_UTF16
      // }else if( strcmp(zCmd, "text16")==0 ){
      // p2 = (const void)sqlite3_value_text16(argv[0]);
      //#endif
      // }else if( strcmp(zCmd, "blob")==0 ){
      // p2 = (const void)sqlite3_value_blob(argv[0]);
      // }else{
      // return;
      // }
      //sqlite3_result_int( context, p1 != p2 ? 1 : 0 );
    }


    /*
    ** Usage: sqlite_test_create_function DB
    **
    ** Call the sqlite3_create_function API on the given database in order
    ** to create a function named "x_coalesce". This function does the same thing
    ** as the "coalesce" function. This function also registers an SQL function
    ** named "x_sqlite_exec" that invokes sqlite3_exec(). Invoking sqlite3_exec()
    ** in this way is illegal recursion and should raise an SQLITE_MISUSE error.
    ** The effect is similar to trying to use the same database connection from
    ** two threads at the same time.
    **
    ** The original motivation for this routine was to be able to call the
    ** sqlite3_create_function function while a query is in progress in order
    ** to test the SQLITE_MISUSE detection logic.
    */
    static int test_create_function(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      int rc;
      sqlite3 db = null;

      if ( argc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " DB\"" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      rc = sqlite3_create_function( db, "x_coalesce", -1, SQLITE_ANY, 0,
      t1_ifnullFunc, null, null );
      if ( rc == SQLITE_OK )
      {
        rc = sqlite3_create_function( db, "hex8", 1, SQLITE_ANY, 0,
        hex8Func, null, null );
      }
#if !SQLITE_OMIT_UTF16
if( rc==SQLITE_OK ){
rc = sqlite3_create_function(db, "hex16", 1, SQLITE_ANY, null, hex16Func, null,null);
}
#endif
      if ( rc == SQLITE_OK )
      {
        rc = sqlite3_create_function( db, "tkt2213func", 1, SQLITE_ANY, 0,
        tkt2213Function, null, null );
      }
      if ( rc == SQLITE_OK )
      {
        rc = sqlite3_create_function( db, "pointer_change", 4, SQLITE_ANY, 0,
        ptrChngFunction, null, null );
      }

#if !SQLITE_OMIT_UTF16
/* Use the sqlite3_create_function16() API here. Mainly for fun, but also
** because it is not tested anywhere else. */
if( rc==SQLITE_OK ){
string zUtf16;
sqlite3_value pVal;
sqlite3_mutex_enter(db.mutex);
pVal = sqlite3ValueNew(db);
sqlite3ValueSetStr(pVal, -1, "x_sqlite_exec", SQLITE_UTF8, SQLITE_STATIC);
zUtf16 = sqlite3ValueText(pVal, SQLITE_UTF16NATIVE);
if( db.mallocFailed !=0{
rc = SQLITE_NOMEM;
}else{
rc = sqlite3_create_function16(db, zUtf16, 1, SQLITE_UTF16, db, sqlite3ExecFunc,null,null );
}
sqlite3ValueFree(ref pVal);
sqlite3_mutex_leave(db.mutex);
}
#endif

      if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
        return TCL.TCL_ERROR;
      TCL.Tcl_SetResult( interp, sqlite3TestErrorName( rc ), 0 );
      return TCL.TCL_OK;
    }

    /*
    ** Routines to implement the x_count() aggregate function.
    **
    ** x_count() counts the number of non-null arguments. But there are
    ** some twists for testing purposes.
    **
    ** If the argument to x_count() is 40 then a UTF-8 error is reported
    ** on the step function. If x_count(41) is seen, then a UTF-16 error
    ** is reported on the step function. If the total count is 42, then
    ** a UTF-8 error is reported on the finalize function.
    */
    //typedef struct t1CountCtx t1CountCtx;

    static void t1CountStep(
    sqlite3_context context,
    int argc,
    sqlite3_value[] argv
    )
    {
      SumCtx p;
      Mem pMem = sqlite3_aggregate_context( context, 1 );//sizeof(*p));
      if ( pMem._SumCtx == null )
        pMem._SumCtx = new SumCtx();
      p = pMem._SumCtx;
      if ( p.Context == null )
        p.Context = pMem;
      if ( ( argc == 0 || SQLITE_NULL != sqlite3_value_type( argv[0] ) ) && p != null )
      {
        p.cnt++;
      }
      if ( argc > 0 )
      {
        int v = sqlite3_value_int( argv[0] );
        if ( v == 40 )
        {
          sqlite3_result_error( context, "value of 40 handed to x_count", -1 );
#if !SQLITE_OMIT_UTF16
}else if( v==41 ){
Debugger.Break (); // TODO --
//const char zUtf16ErrMsg[] = { 0, 0x61, 0, 0x62, 0, 0x63, 0, 0, 0};
//sqlite3_result_error16(context, zUtf16ErrMsg[1-SQLITE_BIGENDIAN], -1);
#endif
        }
      }
    }
    static void t1CountFinalize( sqlite3_context context )
    {
      SumCtx p;
      Mem pMem = sqlite3_aggregate_context( context, 0 );//sizeof(*p));
      p = pMem._SumCtx;
      if ( p != null )
      {
        if ( p.cnt == 42 )
        {
          sqlite3_result_error( context, "x_count totals to 42", -1 );
        }
        else
        {
          sqlite3_result_int( context, p != null ? (int)p.cnt : 0 );
        }
      }
    }

#if !SQLITE_OMIT_DEPRECATED
static void legacyCountStep(
sqlite3_context context,
int argc,
sqlite3_value[] argv
)
{
/* no-op */
}
static void legacyCountFinalize( sqlite3_context context )
{
sqlite3_result_int( context, sqlite3_aggregate_count( context ) );
}
#endif
    /*
** Usage: sqlite3_create_aggregate DB
**
** Call the sqlite3_create_function API on the given database in order
** to create a function named "x_count". This function is similar
** to the built-in count() function, with a few special quirks
** for testing the sqlite3_result_error() APIs.
**
** The original motivation for this routine was to be able to call the
** sqlite3_create_aggregate function while a query is in progress in order
** to test the SQLITE_MISUSE detection logic. See misuse.test.
**
** This routine was later extended to test the use of sqlite3_result_error()
** within aggregate functions.
**
** Later: It is now also extended to register the aggregate function
** "legacy_count()" with the supplied database handle. This is used
** to test the deprecated sqlite3_aggregate_count() API.
*/
    static int test_create_aggregate(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      sqlite3 db = new sqlite3();
      int rc;
      if ( argc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0].ToString(),
        " FILENAME\"" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      rc = sqlite3_create_function( db, "x_count", 0, SQLITE_UTF8, 0, null,
      t1CountStep, t1CountFinalize );
      if ( rc == SQLITE_OK )
      {
        rc = sqlite3_create_function( db, "x_count", 1, SQLITE_UTF8, 0, null,
        t1CountStep, t1CountFinalize );
      }
#if !SQLITE_OMIT_DEPRECATED
if ( rc == SQLITE_OK )
{
rc = sqlite3_create_function( db, "legacy_count", 0, SQLITE_ANY, 0, null,
legacyCountStep, legacyCountFinalize
);
}
#endif
      if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
        return TCL.TCL_ERROR;
      TCL.Tcl_SetResult( interp, t1ErrorName( rc ), 0 );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: printf TEXT
    **
    ** Send output to printf. Use this rather than puts to merge the output
    ** in the correct sequence with debugging printfs inserted into C code.
    ** Puts uses a separate buffer and debugging statements will be out of
    ** sequence if it is used.
    */
    //static int test_printf(
    // object NotUsed,
    // Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    // int argc, /* Number of arguments */
    // Tcl_Obj[] argv /* Text of each argument */
    //){
    // if( argc!=2 ){
    // TCL.Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
    // " TEXT\"");
    // return TCL.TCL_ERROR;
    // }
    // printf("%s\n", argv[1]);
    // return TCL.TCL_OK;
    //}



    /*
    ** Usage: sqlite3_mprintf_int FORMAT INTEGER INTEGER INTEGER
    **
    ** Call mprintf with three integer arguments
    */
    static int sqlite3_mprintf_int(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      long[] a = new long[3];
      int i;
      string z;
      if ( argc != 5 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " FORMAT INT INT INT\"" );
        return TCL.TCL_ERROR;
      }
      for ( i = 2; i < 5; i++ )
      {
        if ( TCL.Tcl_GetLong( interp, argv[i], out a[i - 2] ) )
          return TCL.TCL_ERROR;
      }
      z = sqlite3_mprintf( argv[1].ToString(), a[0], a[1], a[2] );
      TCL.Tcl_AppendResult( interp, z );
      //sqlite3DbFree(db,z);
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_mprintf_int64 FORMAT INTEGER INTEGER INTEGER
    **
    ** Call mprintf with three 64-bit integer arguments
    */
    static int sqlite3_mprintf_int64(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      int i;
      sqlite3_int64[] a = new sqlite3_int64[3];
      string z;
      if ( argc != 5 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " FORMAT INT INT INT\"" );
        return TCL.TCL_ERROR;
      }
      for ( i = 2; i < 5; i++ )
      {
        if ( sqlite3Atoi64( argv[i].ToString(), ref a[i - 2], argv[i].ToString().Length, SQLITE_UTF8 ) != 0 )
        {
          TCL.Tcl_AppendResult( interp, "argument is not a valid 64-bit integer" );
          return TCL.TCL_ERROR;
        }
      }
      z = sqlite3_mprintf( argv[1].ToString(), a[0], a[1], a[2] );
      TCL.Tcl_AppendResult( interp, z );
      //sqlite3DbFree(db,z);
      return TCL.TCL_OK;
    }


    /*
    ** Usage: sqlite3_mprintf_long FORMAT INTEGER INTEGER INTEGER
    **
    ** Call mprintf with three long integer arguments. This might be the
    ** same as sqlite3_mprintf_int or sqlite3_mprintf_int64, depending on
    ** platform.
    */
    static int sqlite3_mprintf_long(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      int i;
      long[] a = new long[3];
      long[] b = new long[3];
      string z;
      if ( argc != 5 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " FORMAT INT INT INT\"" );
        return TCL.TCL_ERROR;
      }
      for ( i = 2; i < 5; i++ )
      {
        if ( TCL.Tcl_GetLong( interp, argv[i], out b[i - 2] ) )
          return TCL.TCL_ERROR;
        a[i - 2] = b[i - 2];
        //a[i-2] &= (((u64)1)<<(sizeof(int)*8))-1;
      }
      z = sqlite3_mprintf( argv[1].ToString(), a[0], a[1], a[2] );
      TCL.Tcl_AppendResult( interp, z );
      ////sqlite3_free(z);
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_mprintf_str FORMAT INTEGER INTEGER STRING
    **
    ** Call mprintf with two integer arguments and one string argument
    */
    static int sqlite3_mprintf_str(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      long[] a = new long[3];
      int i;
      string z;
      if ( argc < 4 || argc > 5 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " FORMAT INT INT ?STRING?\"" );
        return TCL.TCL_ERROR;
      }
      for ( i = 2; i < 4; i++ )
      {
        if ( TCL.Tcl_GetLong( interp, argv[i], out a[i - 2] ) )
          return TCL.TCL_ERROR;
      }
      z = sqlite3_mprintf( argv[1].ToString(), a[0], a[1], argc > 4 ? argv[4].ToString() : null );
      TCL.Tcl_AppendResult( interp, z );
      //sqlite3DbFree(db,z);
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_snprintf_str INTEGER FORMAT INTEGER INTEGER STRING
    **
    ** Call mprintf with two integer arguments and one string argument
    */
    static int sqlite3_snprintf_str(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      long[] a = new long[3];
      int i;
      int n = 0;
      StringBuilder z;
      if ( argc < 5 || argc > 6 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " INT FORMAT INT INT ?STRING?\"" );
        return TCL.TCL_ERROR;
      }
      if ( TCL.Tcl_GetInt( interp, argv[1], out n ) )
        return TCL.TCL_ERROR;
      if ( n < 0 )
      {
        TCL.Tcl_AppendResult( interp, "N must be non-negative" );
        return TCL.TCL_ERROR;
      }
      for ( i = 3; i < 5; i++ )
      {
        if ( TCL.Tcl_GetLong( interp, argv[i], out a[i - 3] ) )
          return TCL.TCL_ERROR;
      }
      z = new StringBuilder( n + 1 );//sqlite3Malloc( n+1 );
      sqlite3_snprintf( n, z, argv[2].ToString(), a[0], a[1], argc > 4 ? argv[5].ToString() : null );
      TCL.Tcl_AppendResult( interp, z );
      //sqlite3DbFree(db,z);
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_mprintf_double FORMAT INTEGER INTEGER DOUBLE
    **
    ** Call mprintf with two integer arguments and one double argument
    */
    static int sqlite3_mprintf_double(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      long[] a = new long[3];
      int i;
      double r = 0;
      string z;
      if ( argc != 5 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " FORMAT INT INT DOUBLE\"" );
        return TCL.TCL_ERROR;
      }
      for ( i = 2; i < 4; i++ )
      {
        if ( TCL.Tcl_GetLong( interp, argv[i], out a[i - 2] ) )
          return TCL.TCL_ERROR;
      }
      if ( TCL.Tcl_GetDouble( interp, argv[4], out r ) )
        return TCL.TCL_ERROR;
      z = sqlite3_mprintf( argv[1].ToString(), a[0], a[1], r );
      TCL.Tcl_AppendResult( interp, z );
      //sqlite3DbFree(db,z);
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_mprintf_scaled FORMAT DOUBLE DOUBLE
    **
    ** Call mprintf with a single double argument which is the product of the
    ** two arguments given above. This is used to generate overflow and underflow
    ** doubles to test that they are converted properly.
    */
    static int sqlite3_mprintf_scaled(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      int i;
      double[] r = new double[2];
      string z;
      if ( argc != 4 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " FORMAT DOUBLE DOUBLE\"" );
        return TCL.TCL_ERROR;
      }
      for ( i = 2; i < 4; i++ )
      {
        if ( TCL.Tcl_GetDouble( interp, argv[i], out r[i - 2] ) )
          return TCL.TCL_ERROR;
      }
      z = sqlite3_mprintf( argv[1].ToString(), r[0] * r[1] );
      TCL.Tcl_AppendResult( interp, z );
      //sqlite3DbFree(db,z);
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_mprintf_stronly FORMAT STRING
    **
    ** Call mprintf with a single double argument which is the product of the
    ** two arguments given above. This is used to generate overflow and underflow
    ** doubles to test that they are converted properly.
    */
    static int sqlite3_mprintf_stronly(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      string z;
      if ( argc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " FORMAT STRING\"" );
        return TCL.TCL_ERROR;
      }
      z = sqlite3_mprintf( argv[1].ToString(), argv[2].ToString() );
      TCL.Tcl_AppendResult( interp, z );
      //sqlite3DbFree( db, z );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_mprintf_hexdouble FORMAT HEX
    **
    ** Call mprintf with a single double argument which is derived from the
    ** hexadecimal encoding of an IEEE double.
    */
    static int sqlite3_mprintf_hexdouble(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      string z;
      double r;
      u32 x1, x2;
      i64 d = 0;
      if ( argc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " FORMAT STRING\"" );
        return TCL.TCL_ERROR;
      }
      //if( sscanf(argv[2].ToString(), "%08x%08x", ref x2, ref x1)!=2 ){
      if ( argv[2].ToString().Length != 16
      || !u32.TryParse( argv[2].ToString().Substring( 0, 8 ), System.Globalization.NumberStyles.HexNumber, null, out x2 )
      || !u32.TryParse( argv[2].ToString().Substring( 8, 8 ), System.Globalization.NumberStyles.HexNumber, null, out x1 )
      )
      {
        TCL.Tcl_AppendResult( interp, "2nd argument should be 16-characters of hex" );
        return TCL.TCL_ERROR;
      }
      d = x2;
      d = ( d << 32 ) + x1;
#if WINDOWS_PHONE
      r = BitConverter.ToDouble(BitConverter.GetBytes((long)d), 0);
#else
      r = BitConverter.Int64BitsToDouble( d );// memcpy( &r, d, sizeof( r ) );
#endif
      z = sqlite3_mprintf( argv[1].ToString(), r );
      TCL.Tcl_AppendResult( interp, z );
      //sqlite3DbFree(db,z);
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_enable_shared_cache ?BOOLEAN?
    **
    */
#if !SQLITE_OMIT_SHARED_CACHE
static int test_enable_shared(
object clientdata, /* Pointer to sqlite3_enable_XXX function */
Tcl_Interp interp, /* The TCL interpreter that invoked this command */
int objc, /* Number of arguments */
Tcl_Obj[] objv /* Command arguments */
)
{
int rc;
bool enable = false;
int ret = 0;

if ( objc != 2 && objc != 1 )
{
TCL.Tcl_WrongNumArgs( interp, 1, objv, "?BOOLEAN?" );
return TCL.TCL_ERROR;
}
ret = sqlite3GlobalConfig.sharedCacheEnabled ? 1 : 0;

if ( objc == 2 )
{
if ( TCL.Tcl_GetBooleanFromObj( interp, objv[1], out enable ) )
{
return TCL.TCL_ERROR;
}
rc = sqlite3_enable_shared_cache( enable );
if ( rc != SQLITE_OK )
{
TCL.Tcl_SetResult( interp, sqlite3ErrStr( rc ), TCL.TCL_STATIC );
return TCL.TCL_ERROR;
}
}
TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewBooleanObj( ret ) );
return TCL.TCL_OK;
}
#endif



    /*
** Usage: sqlite3_extended_result_codes DB BOOLEAN
**
*/
    static int test_extended_result_codes(
    object clientdata, /* Pointer to sqlite3_enable_XXX function */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      bool enable = false;
      sqlite3 db = null;

      if ( objc != 3 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB BOOLEAN" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, objv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      if ( TCL.Tcl_GetBooleanFromObj( interp, objv[2], out enable ) )
        return TCL.TCL_ERROR;
      sqlite3_extended_result_codes( db, enable );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_libversion_number
    **
    */
    static int test_libversion_number(
    object clientdata, /* Pointer to sqlite3_enable_XXX function */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( sqlite3_libversion_number() ) );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_table_column_metadata DB dbname tblname colname
    **
    */
#if SQLITE_ENABLE_COLUMN_METADATA
    static int test_table_column_metadata(
    object clientdata, /* Pointer to sqlite3_enable_XXX function */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      sqlite3 db = null;
      string zDb = null;
      string zTbl = null;
      string zCol = null;
      int rc;
      Tcl_Obj pRet;

      string zDatatype = null;
      string zCollseq = null;
      int notnull = 0;
      int primarykey = 0;
      int autoincrement = 0;

      if ( objc != 5 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB dbname tblname colname" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
        return TCL.TCL_ERROR;
      zDb = TCL.Tcl_GetString( objv[2] );
      zTbl = TCL.Tcl_GetString( objv[3] );
      zCol = TCL.Tcl_GetString( objv[4] );

      if ( zDb.Length == 0 )
        zDb = null;

      rc = sqlite3_table_column_metadata( db, zDb, zTbl, zCol,
      ref zDatatype, ref zCollseq, ref notnull, ref primarykey, ref autoincrement );

      if ( rc != SQLITE_OK )
      {
        TCL.Tcl_AppendResult( interp, sqlite3_errmsg( db ) );
        return TCL.TCL_ERROR;
      }

      pRet = TCL.Tcl_NewObj();
      TCL.Tcl_ListObjAppendElement( null, pRet, TCL.Tcl_NewStringObj( zDatatype, -1 ) );
      TCL.Tcl_ListObjAppendElement( null, pRet, TCL.Tcl_NewStringObj( zCollseq, -1 ) );
      TCL.Tcl_ListObjAppendElement( null, pRet, TCL.Tcl_NewIntObj( notnull ) );
      TCL.Tcl_ListObjAppendElement( null, pRet, TCL.Tcl_NewIntObj( primarykey ) );
      TCL.Tcl_ListObjAppendElement( null, pRet, TCL.Tcl_NewIntObj( autoincrement ) );
      TCL.Tcl_SetObjResult( interp, pRet );

      return TCL.TCL_OK;
    }
#endif

#if !SQLITE_OMIT_INCRBLOB
static int blobHandleFromObj(
Tcl_Interp interp, 
Tcl_Obj *pObj,
sqlite3_blob **ppBlob
){
string z;
int n;

z = TCL.Tcl_GetStringFromObj(pObj, &n);
if( n==0 ){
*ppBlob = 0;
}else{
int notUsed;
TCL.Tcl_Channel channel;
ClientData instanceData;

channel = TCL.Tcl_GetChannel(interp, z, &notUsed);
if( null==channel ) return TCL.TCL_ERROR;

TCL.Tcl_Flush(channel);
TCL.Tcl_Seek(channel, 0, SEEK_SET);

instanceData = TCL.Tcl_GetChannelInstanceData(channel);
*ppBlob = *((sqlite3_blob *)instanceData);
}

return TCL.TCL_OK;
}

/*
** sqlite3_blob_bytes CHANNEL
*/
static int test_blob_bytes(
ClientData clientData, /* Not used */
Tcl_Interp interp, /* The TCL interpreter that invoked this command */
int objc, /* Number of arguments */
Tcl_Obj[] objv /* Command arguments */
){
sqlite3_blob *pBlob;
int nByte;

if( objc!=2 ){
TCL.Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL");
return TCL.TCL_ERROR;
}

if( blobHandleFromObj(interp, objv[1], &pBlob) ) return TCL.TCL_ERROR;
nByte = sqlite3_blob_bytes(pBlob);
TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewIntObj(nByte));

return TCL.TCL_OK;
}

/*
** sqlite3_blob_close CHANNEL
*/
static int test_blob_close(
ClientData clientData, /* Not used */
Tcl_Interp interp, /* The TCL interpreter that invoked this command */
int objc, /* Number of arguments */
Tcl_Obj[] objv /* Command arguments */
){
sqlite3_blob *pBlob;

if( objc!=2 ){
TCL.Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL");
return TCL.TCL_ERROR;
}

if( blobHandleFromObj(interp, objv[1], &pBlob) ) return TCL.TCL_ERROR;
sqlite3_blob_close(pBlob);

return TCL.TCL_OK;
}

/*
** sqlite3_blob_read CHANNEL OFFSET N
**
** This command is used to test the sqlite3_blob_read() in ways that
** the Tcl channel interface does not. The first argument should
** be the name of a valid channel created by the [incrblob] method
** of a database handle. This function calls sqlite3_blob_read()
** to read N bytes from offset OFFSET from the underlying SQLite
** blob handle.
**
** On success, a byte-array object containing the read data is 
** returned. On failure, the interpreter result is set to the
** text representation of the returned error code (i.e. "SQLITE_NOMEM")
** and a Tcl exception is thrown.
*/
static int test_blob_read(
ClientData clientData, /* Not used */
Tcl_Interp interp, /* The TCL interpreter that invoked this command */
int objc, /* Number of arguments */
Tcl_Obj[] objv /* Command arguments */
){
sqlite3_blob *pBlob;
int nByte;
int iOffset;
unsigned string zBuf = 0;
int rc;

if( objc!=4 ){
TCL.Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL OFFSET N");
return TCL.TCL_ERROR;
}

if( blobHandleFromObj(interp, objv[1], &pBlob) ) return TCL.TCL_ERROR;
if( TCL_OK!=TCL.Tcl_GetIntFromObj(interp, objv[2], &iOffset)
|| TCL_OK!=TCL.Tcl_GetIntFromObj(interp, objv[3], &nByte)
){ 
return TCL.TCL_ERROR;
}

if( nByte>0 ){
zBuf = (unsigned char )TCL.Tcl_Alloc(nByte);
}
rc = sqlite3_blob_read(pBlob, zBuf, nByte, iOffset);
if( rc==SQLITE_OK ){
TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewByteArrayObj(zBuf, nByte));
}else{
TCL.Tcl_SetResult(interp, (char )sqlite3TestErrorName(rc), TCL.TCL_VOLATILE);
}
TCL.Tcl_Free((char )zBuf);

return (rc==SQLITE_OK ? TCL_OK : TCL_ERROR);
}

/*
** sqlite3_blob_write CHANNEL OFFSET DATA ?NDATA?
**
** This command is used to test the sqlite3_blob_write() in ways that
** the Tcl channel interface does not. The first argument should
** be the name of a valid channel created by the [incrblob] method
** of a database handle. This function calls sqlite3_blob_write()
** to write the DATA byte-array to the underlying SQLite blob handle.
** at offset OFFSET.
**
** On success, an empty string is returned. On failure, the interpreter
** result is set to the text representation of the returned error code 
** (i.e. "SQLITE_NOMEM") and a Tcl exception is thrown.
*/
static int test_blob_write(
ClientData clientData, /* Not used */
Tcl_Interp interp, /* The TCL interpreter that invoked this command */
int objc, /* Number of arguments */
Tcl_Obj[] objv /* Command arguments */
){
sqlite3_blob *pBlob;
int iOffset;
int rc;

unsigned string zBuf;
int nBuf;

if( objc!=4 && objc!=5 ){
TCL.Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL OFFSET DATA ?NDATA?");
return TCL.TCL_ERROR;
}

if( blobHandleFromObj(interp, objv[1], &pBlob) ) return TCL.TCL_ERROR;
if( TCL_OK!=TCL.Tcl_GetIntFromObj(interp, objv[2], &iOffset) ){ 
return TCL.TCL_ERROR;
}

zBuf = TCL.Tcl_GetByteArrayFromObj(objv[3], &nBuf);
if( objc==5 && TCL.Tcl_GetIntFromObj(interp, objv[4], &nBuf) ){
return TCL.TCL_ERROR;
}
rc = sqlite3_blob_write(pBlob, zBuf, nBuf, iOffset);
if( rc!=SQLITE_OK ){
TCL.Tcl_SetResult(interp, (char )sqlite3TestErrorName(rc), TCL.TCL_VOLATILE);
}

return (rc==SQLITE_OK ? TCL_OK : TCL_ERROR);
}

static int test_blob_reopen(
ClientData clientData, /* Not used */
Tcl_Interp interp, /* The TCL interpreter that invoked this command */
int objc, /* Number of arguments */
Tcl_Obj[] objv /* Command arguments */
){
TCL.Tcl_WideInt iRowid;
sqlite3_blob *pBlob;
int rc;

if( objc!=3 ){
TCL.Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL ROWID");
return TCL.TCL_ERROR;
}

if( blobHandleFromObj(interp, objv[1], &pBlob) ) return TCL.TCL_ERROR;
if( TCL.Tcl_GetWideIntFromObj(interp, objv[2], &iRowid) ) return TCL.TCL_ERROR;

rc = sqlite3_blob_reopen(pBlob, iRowid);
if( rc!=SQLITE_OK ){
TCL.Tcl_SetResult(interp, (char )sqlite3TestErrorName(rc), TCL.TCL_VOLATILE);
}

return (rc==SQLITE_OK ? TCL_OK : TCL_ERROR);
}
#endif

    /*
** Usage: sqlite3_create_collation_v2 DB-HANDLE NAME CMP-PROC DEL-PROC
**
** This Tcl proc is used for testing the experimental
** sqlite3_create_collation_v2() interface.
*/
    public struct TestCollationX
    {
      public Tcl_Interp interp;
      public Tcl_Obj pCmp;
      public Tcl_Obj pDel;
    };
    //typedef struct TestCollationX TestCollationX;
    static void testCreateCollationDel( ref object pCtx )
    {
      TestCollationX p = (TestCollationX)pCtx;

      int rc = TCL.Tcl_EvalObjEx( p.interp, p.pDel, TCL.TCL_EVAL_DIRECT | TCL.TCL_EVAL_GLOBAL );
      if ( rc != TCL.TCL_OK )
      {
        TCL.Tcl_BackgroundError( p.interp );
      }

      TCL.Tcl_DecrRefCount( ref p.pCmp );
      TCL.Tcl_DecrRefCount( ref p.pDel );
      //sqlite3Free(ref p);
    }
    static int testCreateCollationCmp(
    object pCtx,
    int nLeft,
    string zLeft,
    int nRight,
    string zRight
    )
    {
      TestCollationX p = (TestCollationX)pCtx;
      Tcl_Obj pScript = TCL.Tcl_DuplicateObj( p.pCmp );
      int iRes = 0;

      TCL.Tcl_IncrRefCount( pScript );
      TCL.Tcl_ListObjAppendElement( null, pScript, TCL.Tcl_NewStringObj( zLeft, nLeft ) );
      TCL.Tcl_ListObjAppendElement( null, pScript, TCL.Tcl_NewStringObj( zRight, nRight ) );

      if ( TCL.TCL_OK != TCL.Tcl_EvalObjEx( p.interp, pScript, TCL.TCL_EVAL_DIRECT | TCL.TCL_EVAL_GLOBAL )
      || ( TCL.Tcl_GetIntFromObj( p.interp, TCL.Tcl_GetObjResult( p.interp ), out iRes ) != TCL.TCL_OK )
      )
      {
        TCL.Tcl_BackgroundError( p.interp );
      }
      TCL.Tcl_DecrRefCount( ref pScript );

      return iRes;
    }
    static int test_create_collation_v2(
    object clientdata, /* Not used */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      TestCollationX p;
      sqlite3 db = null;
      int rc;

      if ( objc != 5 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB-HANDLE NAME CMP-PROC DEL-PROC" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
        return TCL.TCL_ERROR;

      p = new TestCollationX(); //(TestCollationX )sqlite3Malloc(sizeof(TestCollationX));
      p.pCmp = objv[3];
      p.pDel = objv[4];
      p.interp = interp;
      TCL.Tcl_IncrRefCount( p.pCmp );
      TCL.Tcl_IncrRefCount( p.pDel );

      rc = sqlite3_create_collation_v2( db, TCL.Tcl_GetString( objv[2] ), 16,
      p, (dxCompare)testCreateCollationCmp, testCreateCollationDel
      );
      if ( rc != SQLITE_MISUSE )
      {
        TCL.Tcl_AppendResult( interp, "sqlite3_create_collate_v2() failed to detect " +
        "an invalid encoding" );
        return TCL.TCL_ERROR;
      }
      rc = sqlite3_create_collation_v2( db, TCL.Tcl_GetString( objv[2] ), SQLITE_UTF8,
      p, (dxCompare)testCreateCollationCmp, testCreateCollationDel
      );
      return TCL.TCL_OK;
    }

    /*
    ** USAGE: sqlite3_create_function_v2 DB NAME NARG ENC ?SWITCHES?
    **
    ** Available switches are:
    **
    ** -func SCRIPT
    ** -step SCRIPT
    ** -final SCRIPT
    ** -destroy SCRIPT
    */
    //typedef struct CreateFunctionV2 CreateFunctionV2;
    public class CreateFunctionV2
    {
      public Tcl_Interp interp;
      public Tcl_Obj pFunc; /* Script for function invocation */
      public Tcl_Obj pStep; /* Script for agg. step invocation */
      public Tcl_Obj pFinal; /* Script for agg. finalization invocation */
      public Tcl_Obj pDestroy; /* Destructor script */
    };
    static void cf2Func( sqlite3_context ctx, int nArg, sqlite3_value[] aArg )
    {
    }
    static void cf2Step( sqlite3_context ctx, int nArg, sqlite3_value[] aArg )
    {
    }
    static void cf2Final( sqlite3_context ctx )
    {
    }
    static void cf2Destroy( object pUser )
    {
      CreateFunctionV2 p = (CreateFunctionV2)pUser;

      if ( p.interp != null && p.pDestroy != null )
      {
        int rc = TCL.Tcl_EvalObjEx( p.interp, p.pDestroy, 0 );
        if ( rc != TCL.TCL_OK )
          TCL.Tcl_BackgroundError( p.interp );
      }

      if ( p.pFunc != null )
        TCL.Tcl_DecrRefCount( ref p.pFunc );
      if ( p.pStep != null )
        TCL.Tcl_DecrRefCount( ref p.pStep );
      if ( p.pFinal != null )
        TCL.Tcl_DecrRefCount( ref p.pFinal );
      if ( p.pDestroy != null )
        TCL.Tcl_DecrRefCount( ref p.pDestroy );
      //sqlite3_free( p);
    }

    public class EncTable
    {
      public string zEnc;
      public int enc;

      public EncTable( string zEnc, int enc )
      {
        this.zEnc = zEnc;
        this.enc = enc;
      }
    }

    static int test_create_function_v2(
    ClientData clientData, /* Not used */
    Tcl_Interp interp, /* The invoking TCL interpreter */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      sqlite3 db = null;
      string zFunc;
      int nArg = 0;
      int enc = 0;
      CreateFunctionV2 p;
      int i;
      int rc;

      EncTable[] aEnc = {
new EncTable("utf8", SQLITE_UTF8 ),
new EncTable("utf16", SQLITE_UTF16 ),
new EncTable("utf16le", SQLITE_UTF16LE ),
new EncTable("utf16be", SQLITE_UTF16BE ),
new EncTable("any", SQLITE_ANY ),
new EncTable("0", 0 )
};

      if ( objc < 5 || ( objc % 2 ) == 0 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB NAME NARG ENC SWITCHES..." );
        return TCL.TCL_ERROR;
      }

      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
        return TCL.TCL_ERROR;
      zFunc = TCL.Tcl_GetString( objv[2] );
      if ( TCL.Tcl_GetIntFromObj( interp, objv[3], out nArg ) != 0 )
        return TCL.TCL_ERROR;
      //if ( TCL.Tcl_GetIndexFromObjStruct( interp, objv[4], aEnc,//sizeof(aEnc[0]), 
      // "encoding", 0, ref enc)
      //)
      int iEnc;
      for ( iEnc = 0; iEnc < aEnc.Length && ( aEnc[iEnc].zEnc != objv[4].ToString() ); iEnc++ )
      {
      }
      if ( iEnc >= aEnc.Length )
        return TCL.TCL_ERROR;
      enc = aEnc[iEnc].enc;

      p = new CreateFunctionV2();//sqlite3_malloc( sizeof( CreateFunctionV2 ) );
      //Debug.Assert( p );
      //memset(p, 0, sizeof(CreateFunctionV2));
      p.interp = interp;

      for ( i = 5; i < objc; i += 2 )
      {
        int iSwitch = 0;
        string[] azSwitch = { "-func", "-step", "-final", "-destroy", "" };
        if ( TCL.Tcl_GetIndexFromObj( interp, objv[i], azSwitch, "switch", 0, out iSwitch ) )
        {
          //sqlite3_free(p);
          return TCL.TCL_ERROR;
        }

        switch ( iSwitch )
        {
          case 0:
            p.pFunc = objv[i + 1];
            break;
          case 1:
            p.pStep = objv[i + 1];
            break;
          case 2:
            p.pFinal = objv[i + 1];
            break;
          case 3:
            p.pDestroy = objv[i + 1];
            break;
        }
      }
      if ( p.pFunc != null )
        p.pFunc = TCL.Tcl_DuplicateObj( p.pFunc );
      if ( p.pStep != null )
        p.pStep = TCL.Tcl_DuplicateObj( p.pStep );
      if ( p.pFinal != null )
        p.pFinal = TCL.Tcl_DuplicateObj( p.pFinal );
      if ( p.pDestroy != null )
        p.pDestroy = TCL.Tcl_DuplicateObj( p.pDestroy );

      if ( p.pFunc != null )
        TCL.Tcl_IncrRefCount( p.pFunc );
      if ( p.pStep != null )
        TCL.Tcl_IncrRefCount( p.pStep );
      if ( p.pFinal != null )
        TCL.Tcl_IncrRefCount( p.pFinal );
      if ( p.pDestroy != null )
        TCL.Tcl_IncrRefCount( p.pDestroy );

      rc = sqlite3_create_function_v2( db, zFunc, nArg, enc, p,
      ( p.pFunc != null ? (dxFunc)cf2Func : (dxFunc)null ),
      ( p.pStep != null ? (dxStep)cf2Step : (dxStep)null ),
      ( p.pFinal != null ? (dxFinal)cf2Final : (dxFinal)null ),
      (dxFDestroy)cf2Destroy
      );
      if ( rc != SQLITE_OK )
      {
        TCL.Tcl_ResetResult( interp );
        TCL.Tcl_AppendResult( interp, sqlite3TestErrorName( rc ) );
        return TCL.TCL_ERROR;
      }
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_load_extension DB-HANDLE FILE ?PROC?
    */
    //static int test_load_extension(
    // object clientdata, /* Not used */
    // Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    // int objc, /* Number of arguments */
    // Tcl_Obj[] objv /* Command arguments */
    //){
    // TCL.Tcl_CmdInfo cmdInfo;
    // sqlite3 db=null;
    // int rc;
    // string zDb;
    // string zFile;
    // string zProc = 0;
    // string zErr = 0;

    // if( objc!=4 && objc!=3 ){
    // TCL.Tcl_WrongNumArgs(interp, 1, objv, "DB-HANDLE FILE ?PROC?");
    // return TCL.TCL_ERROR;
    // }
    // zDb = TCL.Tcl_GetString(objv[1]);
    // zFile = TCL.Tcl_GetString(objv[2]);
    // if( objc==4 ){
    // zProc = TCL.Tcl_GetString(objv[3]);
    // }

    // /* Extract the C database handle from the Tcl command name */
    // if( null==TCL.Tcl_GetCommandInfo(interp, zDb, cmdInfo) ){
    // TCL.Tcl_AppendResult(interp, "command not found: ", zDb);
    // return TCL.TCL_ERROR;
    // }
    // db = ((struct SqliteDb)cmdInfo.objclientdata).db;
    // Debug.Assert(db);

    // /* Call the underlying C function. If an error occurs, set rc to
    // ** TCL.TCL_ERROR and load any error string into the interpreter. If no
    // ** error occurs, set rc to TCL.TCL_OK.
    // */
#if SQLITE_OMIT_LOAD_EXTENSION
// rc = SQLITE_ERROR;
// zErr = sqlite3_mprintf("this build omits sqlite3_load_extension()");
#else
    // rc = sqlite3_load_extension(db, zFile, zProc, zErr);
#endif
    // if( rc!=SQLITE_OK ){
    // TCL.Tcl_SetResult(interp, zErr ? zErr : "", TCL.Tcl_VOLATILE);
    // rc = TCL.TCL_ERROR;
    // }else{
    // rc = TCL.TCL_OK;
    // }
    // sqlite3DbFree(db,zErr);

    // return rc;
    //}

    /*
    ** Usage: sqlite3_enable_load_extension DB-HANDLE ONOFF
    */
    //static int test_enable_load(
    // object clientdata, /* Not used */
    // Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    // int objc, /* Number of arguments */
    // Tcl_Obj[] objv /* Command arguments */
    //){
    // TCL.Tcl_CmdInfo cmdInfo;
    // sqlite3 db=null;
    // string zDb;
    // int onoff;

    // if( objc!=3 ){
    // TCL.Tcl_WrongNumArgs(interp, 1, objv, "DB-HANDLE ONOFF");
    // return TCL.TCL_ERROR;
    // }
    // zDb = TCL.Tcl_GetString(objv[1]);

    // /* Extract the C database handle from the Tcl command name */
    // if( null==TCL.Tcl_GetCommandInfo(interp, zDb, cmdInfo) ){
    // TCL.Tcl_AppendResult(interp, "command not found: ", zDb);
    // return TCL.TCL_ERROR;
    // }
    // db = ((struct SqliteDb)cmdInfo.objclientdata).db;
    // Debug.Assert(db);

    // /* Get the onoff parameter */
    // if( TCL.Tcl_GetBooleanFromObj(interp, objv[2], out onoff) ){
    // return TCL.TCL_ERROR;
    // }

#if SQLITE_OMIT_LOAD_EXTENSION
// TCL.Tcl_AppendResult(interp, "this build omits sqlite3_load_extension()");
// return TCL.TCL_ERROR;
#else
    // sqlite3_enable_load_extension(db, onoff);
    // return TCL.TCL_OK;
#endif
    //}

    /*
    ** Usage: sqlite_abort
    **
    ** Shutdown the process immediately. This is not a clean shutdown.
    ** This command is used to test the recoverability of a database in
    ** the event of a program crash.
    */
    //static int sqlite_abort(
    // object NotUsed,
    // Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    // int argc, /* Number of arguments */
    // Tcl_Obj[] argv /* Text of each argument */
    //){
    //#if defined(_MSC_VER)
    // /* We do this, otherwise the test will halt with a popup message
    // * that we have to click away before the test will continue.
    // */
    // _set_abort_behavior( 0, _CALL_REPORTFAULT );
    //#endif
    // exit(255);
    // Debug.Assert( interp==0 ); /* This will always fail */
    // return TCL.TCL_OK;
    //}

    /*
    ** The following routine is a user-defined SQL function whose purpose
    ** is to test the sqlite_set_result() API.
    */
    static void testFunc( sqlite3_context context, int argc, sqlite3_value[] argv )
    {
      int ARGV = 0;
      while ( argc >= 2 )
      {
        string zArg0 = sqlite3_value_text( argv[ARGV] );
        if ( zArg0 != null )
        {
          if ( zArg0.Equals( "int", StringComparison.InvariantCultureIgnoreCase ) )
          {
            sqlite3_result_int( context, sqlite3_value_int( argv[ARGV + 1] ) );
          }
          else if ( zArg0.Equals( "int64", StringComparison.InvariantCultureIgnoreCase ) )
          {
            sqlite3_result_int64( context, sqlite3_value_int64( argv[ARGV + 1] ) );
          }
          else if ( zArg0.Equals( "string", StringComparison.InvariantCultureIgnoreCase ) )
          {
            sqlite3_result_text( context, sqlite3_value_text( argv[ARGV + 1] ), -1,
            SQLITE_TRANSIENT );
          }
          else if ( zArg0.Equals( "double", StringComparison.InvariantCultureIgnoreCase ) )
          {
            sqlite3_result_double( context, sqlite3_value_double( argv[ARGV + 1] ) );
          }
          else if ( zArg0.Equals( "null", StringComparison.InvariantCultureIgnoreCase ) )
          {
            sqlite3_result_null( context );
          }
          else if ( zArg0.Equals( "value", StringComparison.InvariantCultureIgnoreCase ) )
          {
            sqlite3_result_value( context, argv[sqlite3_value_int( argv[ARGV + 1] )] );
          }
          else
          {
            goto error_out;
          }
        }
        else
        {
          goto error_out;
        }
        argc -= 2;
        ARGV += 2;
      }
      return;

error_out:
      sqlite3_result_error( context, "first argument should be one of: " +
      "int int64 string double null value", -1 );
    }

    /*
    ** Usage: sqlite_register_test_function DB NAME
    **
    ** Register the test SQL function on the database DB under the name NAME.
    */
    static int test_register_func(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      sqlite3 db = null;
      int rc;
      if ( argc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " DB FUNCTION-NAME" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      rc = sqlite3_create_function( db, argv[2].ToString(), -1, SQLITE_UTF8, 0,
      testFunc, null, null );
      if ( rc != 0 )
      {
        TCL.Tcl_AppendResult( interp, sqlite3ErrStr( rc ) );
        return TCL.TCL_ERROR;
      }
      if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
        return TCL.TCL_ERROR;
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_finalize STMT
    **
    ** Finalize a statement handle.
    */
    static int test_finalize(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      int rc;
      sqlite3 db = null;

      if ( objc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetStringFromObj( objv[0], 0 ), " <STMT>" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;

      if ( pStmt != null )
      {
        db = sqlite3_db_handle( pStmt );// StmtToDb( pStmt );
      }
      rc = sqlite3_finalize( pStmt );
      TCL.Tcl_SetResult( interp, sqlite3TestErrorName( rc ), TCL.TCL_STATIC );//t1ErrorName( rc ), TCL.TCL_STATIC );
      if ( db != null && sqlite3TestErrCode( interp, db, rc ) != 0 )
        return TCL.TCL_ERROR;
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_stmt_status STMT CODE RESETFLAG
    **
    ** Get the value of a status counter from a statement.
    */
    static int test_stmt_status(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      int iValue;
      int i, op = 0;
      bool resetFlag = false;
      string zOpName;
      sqlite3_stmt pStmt = null;

      //struct _aOp{
      // string zName;
      // int op;
      //} 
      _aOp[] aOp = {
new _aOp( "SQLITE_STMTSTATUS_FULLSCAN_STEP", SQLITE_STMTSTATUS_FULLSCAN_STEP ),
new _aOp( "SQLITE_STMTSTATUS_SORT", SQLITE_STMTSTATUS_SORT ),
new _aOp( "SQLITE_STMTSTATUS_AUTOINDEX", SQLITE_STMTSTATUS_AUTOINDEX )
};

      if ( objc != 4 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "STMT PARAMETER RESETFLAG" );
        return TCL.TCL_ERROR;
      }
      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      zOpName = TCL.Tcl_GetString( objv[2] );
      for ( i = 0; i < ArraySize( aOp ); i++ )
      {
        if ( aOp[i].zName == zOpName )
        {
          op = aOp[i].op;
          break;
        }
      }
      if ( i >= ArraySize( aOp ) )
      {
        if ( TCL.Tcl_GetIntFromObj( interp, objv[2], out op ) != 0 )
          return TCL.TCL_ERROR;
      }
      if ( TCL.Tcl_GetBooleanFromObj( interp, objv[3], out resetFlag ) )
        return TCL.TCL_ERROR;
      iValue = sqlite3_stmt_status( pStmt, op, resetFlag ? 1 : 0 );
      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( iValue ) );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_next_stmt DB STMT
    **
    ** Return the next statment in sequence after STMT.
    */
    static int test_next_stmt(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      sqlite3 db = null;
      StringBuilder zBuf = new StringBuilder( 50 );
      if ( objc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetStringFromObj( objv[0], 0 ), " DB STMT" );
        return TCL.TCL_ERROR;
      }

      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
        return TCL.TCL_ERROR;
      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[2] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      pStmt = sqlite3_next_stmt( db, pStmt );
      if ( pStmt != null )
      {
        if ( sqlite3TestMakePointerStr( interp, zBuf, pStmt ) != 0 )
          return TCL.TCL_ERROR;
        TCL.Tcl_AppendResult( interp, zBuf );
      }
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_stmt_readonly STMT
    **
    ** Return true if STMT is a NULL pointer or a pointer to a statement
    ** that is guaranteed to leave the database unmodified.
    */
    static int test_stmt_readonly(
    object clientData,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      int rc;

      if ( objc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetStringFromObj( objv[0], 0 ), " STMT", 0 );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      rc = sqlite3_stmt_readonly( pStmt ) ? 1 : 0;
      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewBooleanObj( rc ) );
      return TCL.TCL_OK;
    }

    /*
    ** Usage:  uses_stmt_journal  STMT
    **
    ** Return true if STMT uses a statement journal.
    */
    static int uses_stmt_journal(
        object clientdata,
        Tcl_Interp interp,
        int objc,
        Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      int rc;

      if ( objc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
            TCL.Tcl_GetStringFromObj( objv[0], 0 ), " STMT", 0 );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      rc = sqlite3_stmt_readonly( pStmt ) ? 1 : 0;
      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewBooleanObj( pStmt.usesStmtJournal ? 1 : 0 ) );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_reset STMT
    **
    ** Reset a statement handle.
    */
    static int test_reset(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      int rc;

      if ( objc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetStringFromObj( objv[0], 0 ), " <STMT>" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;

      rc = sqlite3_reset( pStmt );
      if ( pStmt != null && sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
      {
        return TCL.TCL_ERROR;
      }
      TCL.Tcl_SetResult( interp, t1ErrorName( rc ), TCL.TCL_STATIC );
      /*
      if( rc !=0){
      return TCL.TCL_ERROR;
      }
      */
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_expired STMT
    **
    ** Return TRUE if a recompilation of the statement is recommended.
    */
    static int test_expired(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
#if !SQLITE_OMIT_DEPRECATED
sqlite3_stmt pStmt = null;
if ( objc != 2 )
{
TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
TCL.Tcl_GetStringFromObj( objv[0], 0 ), " <STMT>" );
return TCL.TCL_ERROR;
}
if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 ) return TCL.TCL_ERROR;
TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewBooleanObj( sqlite3_expired( pStmt ) ) );
#endif
      TCL.Tcl_SetResult( interp, "0", 0 );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3TransferBindings FROMSTMT TOSTMT
    **
    ** Transfer all bindings from FROMSTMT over to TOSTMT
    */
    static int test_transfer_bind(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
#if !SQLITE_OMIT_DEPRECATED
sqlite3_stmt pStmt1 = null, pStmt2 = null;
if ( objc != 3 )
{
TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
TCL.Tcl_GetStringFromObj( objv[0], 0 ), " FROM-STMT TO-STMT" );
return TCL.TCL_ERROR;
}
if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt1 ) != 0 ) return TCL.TCL_ERROR;
if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[2] ), out pStmt2 ) != 0 ) return TCL.TCL_ERROR;
TCL.Tcl_SetObjResult( interp,
TCL.Tcl_NewIntObj( pStmt1.nVar == pStmt2.nVar ? sqlite3TransferBindings( pStmt1, pStmt2 ) : TCL.TCL_ERROR ) );
#endif
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_changes DB
    **
    ** Return the number of changes made to the database by the last SQL
    ** execution.
    */
    static int test_changes(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3 db = null;
      if ( objc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " DB" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
        return TCL.TCL_ERROR;
      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( sqlite3_changes( db ) ) );
      return TCL.TCL_OK;
    }

    /*
    ** This is the "static_bind_value" that variables are bound to when
    ** the FLAG option of sqlite3_bind is "static"
    */
    //static string sqlite_static_bind_value = "";
    //static int sqlite_static_bind_nbyte = 0;

    /*
    ** Usage: sqlite3_bind VM IDX VALUE FLAGS
    **
    ** Sets the value of the IDX-th occurance of "?" in the original SQL
    ** string. VALUE is the new value. If FLAGS=="null" then VALUE is
    ** ignored and the value is set to NULL. If FLAGS=="static" then
    ** the value is set to the value of a static variable named
    ** "sqlite_static_bind_value". If FLAGS=="normal" then a copy
    ** of the VALUE is made. If FLAGS=="blob10" then a VALUE is ignored
    ** an a 10-byte blob "abc\000xyz\000pq" is inserted.
    */
    static int test_bind(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      sqlite3_stmt pStmt = null;
      int rc;
      int idx = 0;
      if ( argc != 5 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " VM IDX VALUE (null|static|normal)\"" );
        return TCL.TCL_ERROR;
      }
      if ( getStmtPointer( interp, argv[1].ToString(), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      if ( TCL.Tcl_GetInt( interp, argv[2], out idx ) )
        return TCL.TCL_ERROR;
      if ( argv[4].ToString() == "null" )
      {
        rc = sqlite3_bind_null( pStmt, idx );
      }
      else if ( argv[4].ToString() == "static" )
      {
        rc = sqlite3_bind_text( pStmt, idx, sqlite_static_bind_value.sValue, -1, null );
      }
      else if ( argv[4].ToString() == "static-nbytes" )
      {
        rc = sqlite3_bind_text( pStmt, idx, sqlite_static_bind_value.sValue,
        sqlite_static_bind_nbyte.iValue, null );
      }
      else if ( argv[4].ToString() == "normal" )
      {
        rc = sqlite3_bind_text( pStmt, idx, argv[3].ToString(), -1, SQLITE_TRANSIENT );
      }
      else if ( argv[4].ToString() == "blob10" )
      {
        rc = sqlite3_bind_text( pStmt, idx, "abc\0xyz\0pq", 10, SQLITE_STATIC );
      }
      else
      {
        TCL.Tcl_AppendResult( interp, "4th argument should be " +
        "\"null\" or \"static\" or \"normal\"" );
        return TCL.TCL_ERROR;
      }
      if ( sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
        return TCL.TCL_ERROR;
      if ( rc != 0 )
      {
        StringBuilder zBuf = new StringBuilder( 50 );
        sqlite3_snprintf( 50, zBuf, "(%d) ", rc );
        TCL.Tcl_SetResult( interp, zBuf + sqlite3ErrStr( rc ), 0 );
        return TCL.TCL_ERROR;
      }
      return TCL.TCL_OK;
    }

#if !SQLITE_OMIT_UTF16
/*
** Usage: add_test_collate <db ptr> <utf8> <utf16le> <utf16be>
**
** This function is used to test that SQLite selects the correct collation
** sequence callback when multiple versions (for different text encodings)
** are available.
**
** Calling this routine registers the collation sequence "test_collate"
** with database handle <db>. The second argument must be a list of three
** boolean values. If the first is true, then a version of test_collate is
** registered for UTF-8, if the second is true, a version is registered for
** UTF-16le, if the third is true, a UTF-16be version is available.
** Previous versions of test_collate are deleted.
**
** The collation sequence test_collate is implemented by calling the
** following TCL script:
**
** "test_collate <enc> <lhs> <rhs>"
**
** The <lhs> and <rhs> are the two values being compared, encoded in UTF-8.
** The <enc> parameter is the encoding of the collation function that
** SQLite selected to call. The TCL test script implements the
** "test_collate" proc.
**
** Note that this will only work with one intepreter at a time, as the
** interp pointer to use when evaluating the TCL script is stored in
** pTestCollateInterp.
*/
//static Tcl_Interp * pTestCollateInterp;
//static int test_collate_func(
// object pCtx,,
// int nA, string zA,
// int nB, string zB
//){
// Tcl_Interp *i = pTestCollateInterp;
// int encin = SQLITE_PTR_TO_INT(pCtx);
// int res;
// int n;

// sqlite3_value pVal;
// Tcl_Obj pX;

// pX = TCL.Tcl_NewStringObj("test_collate", -1);
// TCL.Tcl_IncrRefCount(pX);

// switch( encin ){
// case SQLITE_UTF8:
// TCL.Tcl_ListObjAppendElement(i,pX,TCL.Tcl_NewStringObj("UTF-8",-1));
// break;
// case SQLITE_UTF16LE:
// TCL.Tcl_ListObjAppendElement(i,pX,TCL.Tcl_NewStringObj("UTF-16LE",-1));
// break;
// case SQLITE_UTF16BE:
// TCL.Tcl_ListObjAppendElement(i,pX,TCL.Tcl_NewStringObj("UTF-16BE",-1));
// break;
// default:
// Debug.Assert(false);
// }

//sqlite3BeginBenignMalloc();
// pVal = sqlite3ValueNew(0);
// if( pVal ){
// sqlite3ValueSetStr(pVal, nA, zA, encin, SQLITE_STATIC);
// n = sqlite3_value_bytes(pVal);
// TCL.Tcl_ListObjAppendElement(i,pX,
// TCL.Tcl_NewStringObj((char)sqlite3_value_text(pVal),n));
// sqlite3ValueSetStr(pVal, nB, zB, encin, SQLITE_STATIC);
// n = sqlite3_value_bytes(pVal);
// TCL.Tcl_ListObjAppendElement(i,pX,
// TCL.Tcl_NewStringObj((char)sqlite3_value_text(pVal),n));
// sqlite3ValueFree(pVal);
//}
//sqlite3EndBenignMalloc();

// TCL.Tcl_EvalObjEx(i, pX, 0);
// TCL.Tcl_DecrRefCount(pX);
// TCL.Tcl_GetIntFromObj(i, TCL.Tcl_GetObjResult(i), res);
// return res;
//}
//static int test_collate(
// object clientdata,
// Tcl_Interp interp,
// int objc,
// Tcl_Obj[] objv
//){
// sqlite3 db=null;
// int val;
// sqlite3_value pVal;
// int rc;

// if( objc!=5 ) goto bad_args;
// pTestCollateInterp = interp;
// if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), out db) !=0) return TCL.TCL_ERROR;

// if( TCL.TCL_OK!=TCL.Tcl_GetBooleanFromObj(interp, objv[2], out val) ) return TCL.TCL_ERROR;
// rc = sqlite3_create_collation(db, "test_collate", SQLITE_UTF8,
// (void )SQLITE_UTF8, val?test_collate_func:0);
// if( rc==SQLITE_OK ){
// string zUtf16;
// if( TCL.TCL_OK!=TCL.Tcl_GetBooleanFromObj(interp, objv[3], out val) ) return TCL.TCL_ERROR;
// rc = sqlite3_create_collation(db, "test_collate", SQLITE_UTF16LE,
// (void )SQLITE_UTF16LE, val?test_collate_func:0);
// if( TCL.TCL_OK!=TCL.Tcl_GetBooleanFromObj(interp, objv[4], out val) ) return TCL.TCL_ERROR;

//#if FALSE
// if( sqlite3_iMallocFail>0 ){
// sqlite3_iMallocFail++;
// }
//#endif
// sqlite3_mutex_enter(db.mutex);
// pVal = sqlite3ValueNew(db);
// sqlite3ValueSetStr(pVal, -1, "test_collate", SQLITE_UTF8, SQLITE_STATIC);
// zUtf16 = sqlite3ValueText(pVal, SQLITE_UTF16NATIVE);
// if( db.mallocFailed !=0{
// rc = SQLITE_NOMEM;
// }else{
// rc = sqlite3_create_collation16(db, zUtf16, SQLITE_UTF16BE,
// (void )SQLITE_UTF16BE, val?test_collate_func:0);
// }
// sqlite3ValueFree(pVal);
// sqlite3_mutex_leave(db.mutex);
// }
// if( sqlite3TestErrCode(interp, db, rc) ) return TCL.TCL_ERROR;

// if( rc!=SQLITE_OK ){
// TCL.Tcl_AppendResult(interp, sqlite3TestErrorName(rc));
// return TCL.TCL_ERROR;
// }
// return TCL.TCL_OK;

//bad_args:
// TCL.Tcl_AppendResult(interp, "wrong # args: should be \"",
// TCL.Tcl_GetStringFromObj(objv[0], 0), " <DB> <utf8> <utf16le> <utf16be>", 0);
// return TCL.TCL_ERROR;
//}

/*
** When the collation needed callback is invoked, record the name of
** the requested collating function here. The recorded name is linked
** to a TCL variable and used to make sure that the requested collation
** name is correct.
*/
//static char zNeededCollation[200];
//static char pzNeededCollation = zNeededCollation;


/*
** Called when a collating sequence is needed. Registered using
** sqlite3_collation_needed16().
*/
//static void test_collate_needed_cb(
// object pCtx,,
// sqlite3 db,
// int eTextRep,
// const void pName
//){
// int enc = ENC(db);
// int i;
// string z;
// for(z = (char)pName, i=0; *z || z[1]; z++){
// if( *z ) zNeededCollation[i++] = *z;
// }
// zNeededCollation[i] = 0;
// sqlite3_create_collation(
// db, "test_collate", ENC(db), SQLITE_INT_TO_PTR(enc), test_collate_func);
//}

/*
** Usage: add_test_collate_needed DB
*/
//static int test_collate_needed(
// object clientdata,
// Tcl_Interp interp,
// int objc,
// Tcl_Obj[] objv
//){
// sqlite3 db=null;
// int rc;

// if( objc!=2 ) goto bad_args;
// if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), out db) !=0) return TCL.TCL_ERROR;
// rc = sqlite3_collation_needed16(db, 0, test_collate_needed_cb);
// zNeededCollation[0] = 0;
// if( sqlite3TestErrCode(interp, db, rc) ) return TCL.TCL_ERROR;
// return TCL.TCL_OK;

//bad_args:
// TCL.Tcl_WrongNumArgs(interp, 1, objv, "DB");
// return TCL.TCL_ERROR;
//}

/*
** tclcmd: add_alignment_test_collations DB
**
** Add two new collating sequences to the database DB
**
** utf16_aligned
** utf16_unaligned
**
** Both collating sequences use the same sort order as BINARY.
** The only difference is that the utf16_aligned collating
** sequence is declared with the SQLITE_UTF16_ALIGNED flag.
** Both collating functions increment the unaligned utf16 counter
** whenever they see a string that begins on an odd byte boundary.
*/
//static int unaligned_string_counter = 0;
//static int alignmentCollFunc(
// object NotUsed,
// int nKey1, const void pKey1,
// int nKey2, const void pKey2
//){
// int rc, n;
// n = nKey1<nKey2 ? nKey1 : nKey2;
//if( nKey1>0 && 1==(1&(SQLITE_PTR_TO_INT(pKey1))) ) unaligned_string_counter++;
//if( nKey2>0 && 1==(1&(SQLITE_PTR_TO_INT(pKey2))) ) unaligned_string_counter++;
// rc = memcmp(pKey1, pKey2, n);
// if( rc==0 ){
// rc = nKey1 - nKey2;
// }
// return rc;
//}
//static int add_alignment_test_collations(
// object clientdata,
// Tcl_Interp interp,
// int objc,
// Tcl_Obj[] objv
//){
// sqlite3 db=null;
// if( objc>=2 ){
// if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), out db) !=0) return TCL.TCL_ERROR;
// sqlite3_create_collation(db, "utf16_unaligned", SQLITE_UTF16,
// 0, alignmentCollFunc);
// sqlite3_create_collation(db, "utf16_aligned", SQLITE_UTF16_ALIGNED,
// 0, alignmentCollFunc);
// }
// return SQLITE_OK;
//}
#endif // * !SQLITE_OMIT_UTF16) */

    /*
** Usage: add_test_function <db ptr> <utf8> <utf16le> <utf16be>
**
** This function is used to test that SQLite selects the correct user
** function callback when multiple versions (for different text encodings)
** are available.
**
** Calling this routine registers up to three versions of the user function
** "test_function" with database handle <db>. If the second argument is
** true, then a version of test_function is registered for UTF-8, if the
** third is true, a version is registered for UTF-16le, if the fourth is
** true, a UTF-16be version is available. Previous versions of
** test_function are deleted.
**
** The user function is implemented by calling the following TCL script:
**
** "test_function <enc> <arg>"
**
** Where <enc> is one of UTF-8, UTF-16LE or UTF16BE, and <arg> is the
** single argument passed to the SQL function. The value returned by
** the TCL script is used as the return value of the SQL function. It
** is passed to SQLite using UTF-16BE for a UTF-8 test_function(), UTF-8
** for a UTF-16LE test_function(), and UTF-16LE for an implementation that
** prefers UTF-16BE.
*/
#if !SQLITE_OMIT_UTF16
//static void test_function_utf8(
// sqlite3_context pCtx,
// int nArg,
// sqlite3_value[] argv
//){
// Tcl_Interp interp;
// Tcl_Obj pX;
// sqlite3_value pVal;
// interp = (Tcl_Interp )sqlite3_context_db_handle(pCtx);
// pX = TCL.Tcl_NewStringObj("test_function", -1);
// TCL.Tcl_IncrRefCount(pX);
// TCL.Tcl_ListObjAppendElement(interp, pX, TCL.Tcl_NewStringObj("UTF-8", -1));
// TCL.Tcl_ListObjAppendElement(interp, pX,
// TCL.Tcl_NewStringObj((char)sqlite3_value_text(argv[0]), -1));
// TCL.Tcl_EvalObjEx(interp, pX, 0);
// TCL.Tcl_DecrRefCount(pX);
// sqlite3_result_text(pCtx, TCL.Tcl_GetStringResult(interp), -1, SQLITE_TRANSIENT);
// pVal = sqlite3ValueNew(0);
// sqlite3ValueSetStr(pVal, -1, TCL.Tcl_GetStringResult(interp),
// SQLITE_UTF8, SQLITE_STATIC);
// sqlite3_result_text16be(pCtx, sqlite3_value_text16be(pVal),
// -1, SQLITE_TRANSIENT);
// sqlite3ValueFree(pVal);
//}
//static void test_function_utf16le(
// sqlite3_context pCtx,
// int nArg,
// sqlite3_value[] argv
//){
// Tcl_Interp interp;
// Tcl_Obj pX;
// sqlite3_value pVal;
// interp = (Tcl_Interp )sqlite3_context_db_handle(pCtx);
// pX = TCL.Tcl_NewStringObj("test_function", -1);
// TCL.Tcl_IncrRefCount(pX);
// TCL.Tcl_ListObjAppendElement(interp, pX, TCL.Tcl_NewStringObj("UTF-16LE", -1));
// TCL.Tcl_ListObjAppendElement(interp, pX,
// TCL.Tcl_NewStringObj((char)sqlite3_value_text(argv[0]), -1));
// TCL.Tcl_EvalObjEx(interp, pX, 0);
// TCL.Tcl_DecrRefCount(pX);
// pVal = sqlite3ValueNew(0);
// sqlite3ValueSetStr(pVal, -1, TCL.Tcl_GetStringResult(interp),
// SQLITE_UTF8, SQLITE_STATIC);
// sqlite3_result_text(pCtx,(char)sqlite3_value_text(pVal),-1,SQLITE_TRANSIENT);
// sqlite3ValueFree(pVal);
//}
//static void test_function_utf16be(
// sqlite3_context pCtx,
// int nArg,
// sqlite3_value[] argv
//){
// Tcl_Interp interp;
// Tcl_Obj pX;
// sqlite3_value pVal;
// interp = (Tcl_Interp )sqlite3_context_db_handle(pCtx);
// pX = TCL.Tcl_NewStringObj("test_function", -1);
// TCL.Tcl_IncrRefCount(pX);
// TCL.Tcl_ListObjAppendElement(interp, pX, TCL.Tcl_NewStringObj("UTF-16BE", -1));
// TCL.Tcl_ListObjAppendElement(interp, pX,
// TCL.Tcl_NewStringObj((char)sqlite3_value_text(argv[0]), -1));
// TCL.Tcl_EvalObjEx(interp, pX, 0);
// TCL.Tcl_DecrRefCount(pX);
// pVal = sqlite3ValueNew(0);
// sqlite3ValueSetStr(pVal, -1, TCL.Tcl_GetStringResult(interp),
// SQLITE_UTF8, SQLITE_STATIC);
// sqlite3_result_text16(pCtx, sqlite3_value_text16le(pVal),
// -1, SQLITE_TRANSIENT);
// sqlite3_result_text16be(pCtx, sqlite3_value_text16le(pVal),
// -1, SQLITE_TRANSIENT);
// sqlite3_result_text16le(pCtx, sqlite3_value_text16le(pVal),
// -1, SQLITE_TRANSIENT);
// sqlite3ValueFree(pVal);
//}
#endif // * SQLITE_OMIT_UTF16 */
    //static int test_function(
    // object clientdata,
    // Tcl_Interp interp,
    // int objc,
    // Tcl_Obj[] objv
    //){
#if !SQLITE_OMIT_UTF16
// sqlite3 db=null;
// int val;

// if( objc!=5 ) goto bad_args;
// if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), out db) !=0) return TCL.TCL_ERROR;

// if( TCL.TCL_OK!=TCL.Tcl_GetBooleanFromObj(interp, objv[2], out val) ) return TCL.TCL_ERROR;
// if( val ){
// sqlite3_create_function(db, "test_function", 1, SQLITE_UTF8,
// interp, test_function_utf8, 0, 0);
// }
// if( TCL.TCL_OK!=TCL.Tcl_GetBooleanFromObj(interp, objv[3], out val) ) return TCL.TCL_ERROR;
// if( val ){
// sqlite3_create_function(db, "test_function", 1, SQLITE_UTF16LE,
// interp, test_function_utf16le, 0, 0);
// }
// if( TCL.TCL_OK!=TCL.Tcl_GetBooleanFromObj(interp, objv[4], out val) ) return TCL.TCL_ERROR;
// if( val ){
// sqlite3_create_function(db, "test_function", 1, SQLITE_UTF16BE,
// interp, test_function_utf16be, 0, 0);
// }

// return TCL.TCL_OK;
//bad_args:
// TCL.Tcl_AppendResult(interp, "wrong # args: should be \"",
// TCL.Tcl_GetStringFromObj(objv[0], 0), " <DB> <utf8> <utf16le> <utf16be>", 0);
#endif // * SQLITE_OMIT_UTF16 */
    // return TCL.TCL_ERROR;
    //}

    /*
    ** Usage: test_errstr <err code>
    **
    ** Test that the english language string equivalents for sqlite error codes
    ** are sane. The parameter is an integer representing an sqlite error code.
    ** The result is a list of two elements, the string representation of the
    ** error code and the english language explanation.
    */
    static int test_errstr(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      string zCode;
      int i;
      if ( objc != 2 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "<error code>" );
      }

      zCode = TCL.Tcl_GetString( objv[1] );
      for ( i = 0; i < 200; i++ )
      {
        if ( t1ErrorName( i ).Equals( zCode ) )
          break;
      }
      TCL.Tcl_SetResult( interp, sqlite3ErrStr( i ), 0 );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: breakpoint
    **
    ** This routine exists for one purpose - to provide a place to put a
    ** breakpoint with GDB that can be triggered using TCL code. The use
    ** for this is when a particular test fails on (say) the 1485th iteration.
    ** In the TCL test script, we can add code like this:
    **
    ** if {$i==1485} breakpoint
    **
    ** Then run testfixture in the debugger and wait for the breakpoint to
    ** fire. Then additional breakpoints can be set to trace down the bug.
    */
    static int test_breakpoint(
    object NotUsed,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int argc, /* Number of arguments */
    Tcl_Obj[] argv /* Text of each argument */
    )
    {
      return TCL.TCL_OK; /* Do nothing */
    }

    /*
    ** Usage: sqlite3_bind_zeroblob STMT IDX N
    **
    ** Test the sqlite3_bind_zeroblob interface. STMT is a prepared statement.
    ** IDX is the index of a wildcard in the prepared statement. This command
    ** binds a N-byte zero-filled BLOB to the wildcard.
    */
    static int test_bind_zeroblob(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      int idx = 0;
      int n = 0;
      int rc;

      if ( objc != 4 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "STMT IDX N" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out idx ) )
        return TCL.TCL_ERROR;
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[3], out n ) )
        return TCL.TCL_ERROR;

      rc = sqlite3_bind_zeroblob( pStmt, idx, n );
      if ( sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
        return TCL.TCL_ERROR;
      if ( rc != SQLITE_OK )
      {
        return TCL.TCL_ERROR;
      }

      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_bind_int STMT N VALUE
    **
    ** Test the sqlite3_bind_int interface. STMT is a prepared statement.
    ** N is the index of a wildcard in the prepared statement. This command
    ** binds a 32-bit integer VALUE to that wildcard.
    */
    static int test_bind_int(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      int idx = 0;
      int value = 0;
      int rc;

      if ( objc != 4 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetStringFromObj( objv[0], 0 ), " STMT N VALUE" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out idx ) )
        return TCL.TCL_ERROR;
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[3], out value ) )
        return TCL.TCL_ERROR;

      rc = sqlite3_bind_int( pStmt, idx, value );
      if ( sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
        return TCL.TCL_ERROR;
      if ( rc != SQLITE_OK )
      {
        return TCL.TCL_ERROR;
      }

      return TCL.TCL_OK;
    }


    /*
    ** Usage: sqlite3_bind_int64 STMT N VALUE
    **
    ** Test the sqlite3_bind_int64 interface. STMT is a prepared statement.
    ** N is the index of a wildcard in the prepared statement. This command
    ** binds a 64-bit integer VALUE to that wildcard.
    */
    static int test_bind_int64(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      int idx = 0;
      i64 value = 0;
      int rc;

      if ( objc != 4 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetStringFromObj( objv[0], 0 ), " STMT N VALUE" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out idx ) )
        return TCL.TCL_ERROR;
      if ( TCL.Tcl_GetWideIntFromObj( interp, objv[3], out value ) )
        return TCL.TCL_ERROR;

      rc = sqlite3_bind_int64( pStmt, idx, value );
      if ( sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
        return TCL.TCL_ERROR;
      if ( rc != SQLITE_OK )
      {
        return TCL.TCL_ERROR;
      }

      return TCL.TCL_OK;
    }


    /*
    ** Usage: sqlite3_bind_double STMT N VALUE
    **
    ** Test the sqlite3_bind_double interface. STMT is a prepared statement.
    ** N is the index of a wildcard in the prepared statement. This command
    ** binds a 64-bit integer VALUE to that wildcard.
    */
    class _aSpecialFp
    {
      public string zName; /* Name of the special floating point value */
      public u32 iUpper; /* Upper 32 bits */
      public u32 iLower; /* Lower 32 bits */
      public _aSpecialFp( string zName, u32 iUpper, u32 iLower )
      {
        this.zName = zName;
        this.iUpper = iUpper;
        this.iLower = iLower;
      }
    }

    static int test_bind_double(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      ;
      int idx = 0;
      double value = 0;
      int rc;
      string zVal;
      int i;
      _aSpecialFp[] aSpecialFp = new _aSpecialFp[] {
new _aSpecialFp( "NaN", 0x7fffffff, 0xffffffff ),
new _aSpecialFp( "SNaN", 0x7ff7ffff, 0xffffffff ),
new _aSpecialFp( "-NaN", 0xffffffff, 0xffffffff ),
new _aSpecialFp( "-SNaN", 0xfff7ffff, 0xffffffff ),
new _aSpecialFp( "+Inf", 0x7ff00000, 0x00000000 ),
new _aSpecialFp( "-Inf", 0xfff00000, 0x00000000 ),
new _aSpecialFp( "Epsilon", 0x00000000, 0x00000001 ),
new _aSpecialFp( "-Epsilon", 0x80000000, 0x00000001 ),
new _aSpecialFp( "NaN0", 0x7ff80000, 0x00000000 ),
new _aSpecialFp( "-NaN0", 0xfff80000, 0x00000000 ),
};

      if ( objc != 4 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetStringFromObj( objv[0], 0 ), " STMT N VALUE" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out idx ) )
        return TCL.TCL_ERROR;

      /* Intercept the string "NaN" and generate a NaN value for it.
      ** All other strings are passed through to TCL.Tcl_GetDoubleFromObj().
      ** TCL.Tcl_GetDoubleFromObj() should understand "NaN" but some versions
      ** contain a bug.
      */
      zVal = TCL.Tcl_GetString( objv[3] );
      for ( i = 0; i < aSpecialFp.Length; i++ )
      {//sizeof(aSpecialFp)/sizeof(aSpecialFp[0]); i++){
        if ( aSpecialFp[i].zName == zVal )
        {
          i64 x;
          x = aSpecialFp[i].iUpper;
          x <<= 32;
          x |= aSpecialFp[i].iLower;
          Debug.Assert( sizeof( double ) == 8 );
          Debug.Assert( sizeof( sqlite3_u3264 ) == 8 );
#if WINDOWS_PHONE
          value = BitConverter.ToDouble(BitConverter.GetBytes((long)x), 0);
#else
          value = BitConverter.Int64BitsToDouble( x );//memcpy(&value, x, 8);
#endif
          //value = Double.NaN;
          break;
        }
      }
      if ( ( i >= aSpecialFp.Length ) && //sizeof(aSpecialFp)/sizeof(aSpecialFp[0]) &&
      TCL.Tcl_GetDoubleFromObj( interp, objv[3], out value ) )
      {
        return TCL.TCL_ERROR;
      }
      rc = sqlite3_bind_double( pStmt, idx, value );
      if ( sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
        return TCL.TCL_ERROR;
      if ( rc != SQLITE_OK )
      {
        return TCL.TCL_ERROR;
      }

      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_bind_null STMT N
    **
    ** Test the sqlite3_bind_null interface. STMT is a prepared statement.
    ** N is the index of a wildcard in the prepared statement. This command
    ** binds a NULL to the wildcard.
    */
    static int test_bind_null(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      ;
      int idx = 0;
      int rc;

      if ( objc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetStringFromObj( objv[0], 0 ), " STMT N" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out idx ) )
        return TCL.TCL_ERROR;

      rc = sqlite3_bind_null( pStmt, idx );
      if ( sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
        return TCL.TCL_ERROR;
      if ( rc != SQLITE_OK )
      {
        return TCL.TCL_ERROR;
      }

      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_bind_text STMT N STRING BYTES
    **
    ** Test the sqlite3_bind_text interface. STMT is a prepared statement.
    ** N is the index of a wildcard in the prepared statement. This command
    ** binds a UTF-8 string STRING to the wildcard. The string is BYTES bytes
    ** long.
    */
    static int test_bind_text(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      int idx = 0;
      int bytes = 0;
      byte[] value;
      int rc;

      if ( objc != 5 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetStringFromObj( objv[0], 0 ), " STMT N VALUE BYTES" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out idx ) )
        return TCL.TCL_ERROR;
      value = TCL.Tcl_GetByteArrayFromObj( objv[3], out bytes );
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[4], out bytes ) )
        return TCL.TCL_ERROR;

      rc = sqlite3_bind_text( pStmt, idx, Encoding.UTF8.GetString( value, 0, value.Length ), bytes, SQLITE_TRANSIENT );
      if ( sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
        return TCL.TCL_ERROR;
      if ( rc != SQLITE_OK )
      {
        TCL.Tcl_AppendResult( interp, sqlite3TestErrorName( rc ) );
        return TCL.TCL_ERROR;
      }

      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_bind_text16 ?-static? STMT N STRING BYTES
    **
    ** Test the sqlite3_bind_text16 interface. STMT is a prepared statement.
    ** N is the index of a wildcard in the prepared statement. This command
    ** binds a UTF-16 string STRING to the wildcard. The string is BYTES bytes
    ** long.
    */
    static int test_bind_text16(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
#if !SQLITE_OMIT_UTF16
sqlite3_stmt pStmt=null;
int idx=0;
int bytes=0;
string value;
int rc;

dxDel xDel = (objc==6?SQLITE_STATIC:SQLITE_TRANSIENT);
Tcl_Obj oStmt = objv[objc-4];
Tcl_Obj oN = objv[objc-3];
Tcl_Obj oString = objv[objc-2];
Tcl_Obj oBytes = objv[objc-1];

if( objc!=5 && objc!=6){
TCL.Tcl_AppendResult(interp, "wrong # args: should be \"",
TCL.Tcl_GetStringFromObj(objv[0], 0), " STMT N VALUE BYTES", 0);
return TCL.TCL_ERROR;
}

if( getStmtPointer(interp, TCL.Tcl_GetString(oStmt), out pStmt)!=0 ) return TCL.TCL_ERROR;
if( TCL.Tcl_GetIntFromObj(interp, oN, out idx) ) return TCL.TCL_ERROR;
int dummy0 = 0;
value = Encoding.UTF8.GetString(TCL.Tcl_GetByteArrayFromObj( oString, out dummy0 ));
if( TCL.Tcl_GetIntFromObj(interp, oBytes, out bytes) ) return TCL.TCL_ERROR;

rc = sqlite3_bind_text16(pStmt, idx, value, bytes, xDel);
if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) !=0) return TCL.TCL_ERROR;
if( rc!=SQLITE_OK ){
TCL.Tcl_AppendResult(interp, sqlite3TestErrorName(rc));
return TCL.TCL_ERROR;
}

#endif // * SQLITE_OMIT_UTF16 */
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_bind_blob ?-static? STMT N DATA BYTES
    **
    ** Test the sqlite3_bind_blob interface. STMT is a prepared statement.
    ** N is the index of a wildcard in the prepared statement. This command
    ** binds a BLOB to the wildcard. The BLOB is BYTES bytes in size.
    */
    static int test_bind_blob(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      int idx = 0;
      int bytes = 0;
      byte[] value;
      int rc;
      dxDel xDestructor = SQLITE_TRANSIENT;

      int iObjv = 0;
      if ( objc != 5 && objc != 6 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetStringFromObj( objv[0], 0 ), " STMT N DATA BYTES" );
        return TCL.TCL_ERROR;
      }

      if ( objc == 6 )
      {
        xDestructor = SQLITE_STATIC;
        iObjv++;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[iObjv + 1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[iObjv + 2], out idx ) )
        return TCL.TCL_ERROR;
      value = Encoding.UTF8.GetBytes( TCL.Tcl_GetString( objv[iObjv + 3] ) );
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[iObjv + 4], out bytes ) )
        return TCL.TCL_ERROR;

      rc = sqlite3_bind_blob( pStmt, idx, value, bytes, xDestructor );
      if ( sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
        return TCL.TCL_ERROR;
      if ( rc != SQLITE_OK )
      {
        return TCL.TCL_ERROR;
      }

      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_bind_parameter_count STMT
    **
    ** Return the number of wildcards in the given statement.
    */
    static int test_bind_parameter_count(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;

      if ( objc != 2 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "STMT" );
        return TCL.TCL_ERROR;
      }
      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( sqlite3_bind_parameter_count( pStmt ) ) );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_bind_parameter_name STMT N
    **
    ** Return the name of the Nth wildcard. The first wildcard is 1.
    ** An empty string is returned if N is out of range or if the wildcard
    ** is nameless.
    */
    static int test_bind_parameter_name(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      int i = 0;

      if ( objc != 3 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "STMT N" );
        return TCL.TCL_ERROR;
      }
      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out i ) )
        return TCL.TCL_ERROR;
      TCL.Tcl_SetObjResult( interp,
      TCL.Tcl_NewStringObj( sqlite3_bind_parameter_name( pStmt, i ), -1 )
      );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_bind_parameter_index STMT NAME
    **
    ** Return the index of the wildcard called NAME. Return 0 if there is
    ** no such wildcard.
    */
    static int test_bind_parameter_index(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;

      if ( objc != 3 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "STMT NAME" );
        return TCL.TCL_ERROR;
      }
      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      TCL.Tcl_SetObjResult( interp,
      TCL.Tcl_NewIntObj(
      sqlite3_bind_parameter_index( pStmt, TCL.Tcl_GetString( objv[2] ) )
      )
      );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_clear_bindings STMT
    **
    */
    static int test_clear_bindings(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;

      if ( objc != 2 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "STMT" );
        return TCL.TCL_ERROR;
      }
      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( sqlite3_clear_bindings( pStmt ) ) );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_sleep MILLISECONDS
    */
    static int test_sleep(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      int ms = 0;

      if ( objc != 2 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "MILLISECONDS" );
        return TCL.TCL_ERROR;
      }
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[1], out ms ) )
      {
        return TCL.TCL_ERROR;
      }
      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( sqlite3_sleep( ms ) ) );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_extended_errcode DB
    **
    ** Return the string representation of the most recent sqlite3_* API
    ** error code. e.g. "SQLITE_ERROR".
    */
    static int test_ex_errcode(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3 db = null;
      int rc;

      if ( objc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " DB" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
        return TCL.TCL_ERROR;
      rc = sqlite3_extended_errcode( db );
      TCL.Tcl_AppendResult( interp, t1ErrorName( rc ) );
      return TCL.TCL_OK;
    }


    /*
    ** Usage: sqlite3_errcode DB
    **
    ** Return the string representation of the most recent sqlite3_* API
    ** error code. e.g. "SQLITE_ERROR".
    */
    static int test_errcode(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3 db = null;
      int rc;
      StringBuilder zBuf = new StringBuilder( 50 );

      if ( objc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " DB" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
        return TCL.TCL_ERROR;
      rc = sqlite3_errcode( db );
      if ( ( rc & 0xff ) == rc )
      {
        zBuf.Length = 0;
      }
      else
      {
        sqlite3_snprintf( 30, zBuf, "+%d", rc >> 8 );
      }
      TCL.Tcl_AppendResult( interp, t1ErrorName( rc ), zBuf );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_errmsg DB
    **
    ** Returns the UTF-8 representation of the error message string for the
    ** most recent sqlite3_* API call.
    */
    static int test_errmsg(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3 db = null;
      string zErr;

      if ( objc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " DB" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
        return TCL.TCL_ERROR;

      zErr = sqlite3_errmsg( db );
      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewStringObj( zErr, -1 ) );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: test_errmsg16 DB
    **
    ** Returns the UTF-16 representation of the error message string for the
    ** most recent sqlite3_* API call. This is a byte array object at the TCL
    ** level, and it includes the 0x00 0x00 terminator bytes at the end of the
    ** UTF-16 string.
    */
    //static int test_errmsg16(
    // object clientdata,
    // Tcl_Interp interp,
    // int objc,
    // Tcl_Obj[] objv
    //){
#if !SQLITE_OMIT_UTF16
sqlite3 db;
string zErr;
string z;
int bytes = 0;

if( objc!=2 ){
TCL.Tcl_AppendResult(interp, "wrong # args: should be \"",
TCL.Tcl_GetString(objv[0]), " DB", 0);
return TCL.TCL_ERROR;
}
if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), &db) ) return TCL.TCL_ERROR;

zErr = sqlite3_errmsg16(db);
if( zErr ){
z = zErr;
for(bytes=0; z[bytes] || z[bytes+1]; bytes+=2){}
}
TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewByteArrayObj(zErr, bytes));
#endif // * SQLITE_OMIT_UTF16 */
    // return TCL.TCL_OK;
    //}

    /*
    ** Usage: sqlite3_prepare DB sql bytes ?tailvar?
    **
    ** Compile up to <bytes> bytes of the supplied SQL string <sql> using
    ** database handle <DB>. The parameter <tailval> is the name of a global
    ** variable that is set to the unused portion of <sql> (if any). A
    ** STMT handle is returned.
    */
    static int test_prepare(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3 db = null;
      string zSql;
      int bytes = 0;
      string zTail = "";
      sqlite3_stmt pStmt = null;
      StringBuilder zBuf = new StringBuilder( 50 );
      int rc;

      if ( objc != 5 && objc != 4 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " DB sql bytes ?tailvar?" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
        return TCL.TCL_ERROR;
      zSql = TCL.Tcl_GetString( objv[2] );
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[3], out bytes ) )
        return TCL.TCL_ERROR;

      if ( bytes > zSql.Length )
        bytes = zSql.Length;
      rc = sqlite3_prepare( db, zSql, bytes, ref pStmt, ref zTail );
      TCL.Tcl_ResetResult( interp );
      if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
        return TCL.TCL_ERROR;
      if ( zTail != null && objc >= 5 )
      {
        if ( bytes >= 0 )
        {
          bytes = bytes - zSql.Length - zTail.Length;// ( zTail - zSql );
        }
        if ( zTail.Length < bytes )
        {
          bytes = zTail.Length;
        }
        TCL.Tcl_ObjSetVar2( interp, objv[4], null, TCL.Tcl_NewStringObj( zTail, bytes ), 0 );
      }
      if ( rc != SQLITE_OK )
      {
        Debug.Assert( pStmt == null );
        sqlite3_snprintf( 200, zBuf, "(%d) ", rc );
        TCL.Tcl_SetResult( interp, zBuf + sqlite3_errmsg( db ), 0 );
        return TCL.TCL_ERROR;
      }

      if ( pStmt != null )
      {
        if ( sqlite3TestMakePointerStr( interp, zBuf, pStmt ) != 0 )
          return TCL.TCL_ERROR;
        TCL.Tcl_AppendResult( interp, zBuf, null );
      }
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_prepare_v2 DB sql bytes ?tailvar?
    **
    ** Compile up to <bytes> bytes of the supplied SQL string <sql> using
    ** database handle <DB>. The parameter <tailval> is the name of a global
    ** variable that is set to the unused portion of <sql> (if any). A
    ** STMT handle is returned.
    */
    static int test_prepare_v2(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3 db = null;
      string zSql;
      int bytes = 0;
      string zTail = "";
      sqlite3_stmt pStmt = null;
      StringBuilder zBuf = new StringBuilder( 50 );
      int rc;

      if ( objc != 5 && objc != 4 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " DB sql bytes ?tailvar?", null );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
        return TCL.TCL_ERROR;
      zSql = TCL.Tcl_GetString( objv[2] );
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[3], out bytes ) )
        return TCL.TCL_ERROR;

      rc = sqlite3_prepare_v2( db, zSql, bytes, ref pStmt, ref zTail );
      Debug.Assert( rc == SQLITE_OK || pStmt == null );
      TCL.Tcl_ResetResult( interp );
      if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
        return TCL.TCL_ERROR;
      if ( zTail != null && objc >= 5 )
      {
        if ( bytes >= 0 )
        {
          bytes = bytes - zSql.Length - zTail.Length;// ( zTail - zSql );
        }
        TCL.Tcl_ObjSetVar2( interp, objv[4], null, TCL.Tcl_NewStringObj( zTail, bytes ), 0 );
      }
      if ( rc != SQLITE_OK )
      {
        Debug.Assert( pStmt == null );
        sqlite3_snprintf( 50, zBuf, "(%d) ", rc );
        TCL.Tcl_AppendResult( interp, zBuf, sqlite3_errmsg( db ) );
        return TCL.TCL_ERROR;
      }

      if ( pStmt != null )
      {
        if ( sqlite3TestMakePointerStr( interp, zBuf, pStmt ) != 0 )
          return TCL.TCL_ERROR;
        TCL.Tcl_AppendResult( interp, zBuf );
      }
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_prepare_tkt3134 DB
    **
    ** Generate a prepared statement for a zero-byte string as a test
    ** for ticket #3134. The string should be preceeded by a zero byte.
    */
    static int test_prepare_tkt3134(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3 db = null;
      string zSql = "\000SELECT 1";
      sqlite3_stmt pStmt = null;
      StringBuilder zBuf = new StringBuilder( 50 );
      int rc;

      if ( objc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " DB sql bytes tailvar" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
        return TCL.TCL_ERROR;
      rc = sqlite3_prepare_v2( db, zSql.Substring( 1 ), 0, ref pStmt, 0 );
      Debug.Assert( rc == SQLITE_OK || pStmt == null );
      if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
        return TCL.TCL_ERROR;
      if ( rc != SQLITE_OK )
      {
        Debug.Assert( pStmt == null );
        zBuf.Length = 0;
        zBuf.Append( rc.ToString() ); //sprintf( zBuf, "(%d) ", rc );
        TCL.Tcl_AppendResult( interp, zBuf, sqlite3_errmsg( db ) );
        return TCL.TCL_ERROR;
      }

      if ( pStmt != null )
      {
        if ( sqlite3TestMakePointerStr( interp, zBuf, pStmt ) != 0 )
          return TCL.TCL_ERROR;
        TCL.Tcl_AppendResult( interp, zBuf );
      }
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_prepare16 DB sql bytes tailvar
    **
    ** Compile up to <bytes> bytes of the supplied SQL string <sql> using
    ** database handle <DB>. The parameter <tailval> is the name of a global
    ** variable that is set to the unused portion of <sql> (if any). A
    ** STMT handle is returned.
    */
    static int test_prepare16(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
#if !SQLITE_OMIT_UTF16
sqlite3 db=null;
string zSql;
string zTail = 0;
Tcl_Obj pTail = 0;
sqlite3_stmt pStmt = null;
char zBuf[50];
int rc;
int bytes; /* The integer specified as arg 3 */
int objlen; /* The byte-array length of arg 2 */

if( objc!=5 && objc!=4 ){
TCL.Tcl_AppendResult(interp, "wrong # args: should be \"",
TCL.Tcl_GetString(objv[0]), " DB sql bytes ?tailvar?", 0);
return TCL.TCL_ERROR;
}
if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), out db) !=0) return TCL.TCL_ERROR;
zSql = TCL.Tcl_GetByteArrayFromObj(objv[2], out objlen);
if( TCL.Tcl_GetIntFromObj(interp, objv[3], out bytes) ) return TCL.TCL_ERROR;

rc = sqlite3_prepare16(db, zSql, bytes, pStmt, objc>=5 ? &zTail : 0);
if( sqlite3TestErrCode(interp, db, rc) ) return TCL.TCL_ERROR;
if( rc !=0){
return TCL.TCL_ERROR;
}

if( objc>=5 ){
if( zTail ){
objlen = objlen - ((u8 )zTail-(u8 )zSql);
}else{
objlen = 0;
}
pTail = TCL.Tcl_NewByteArrayObj((u8 )zTail, objlen);
TCL.Tcl_IncrRefCount(pTail);
Tcl_ObjSetVar2(interp, objv[4], 0, pTail, 0);
TCL.Tcl_DecrRefCount(pTail);
}

if( pStmt ){
if( sqlite3TestMakePointerStr(interp, zBuf, pStmt) ) return TCL.TCL_ERROR;
}
TCL.Tcl_AppendResult(interp, zBuf);
#endif // * SQLITE_OMIT_UTF16 */
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_prepare16_v2 DB sql bytes tailvar
    **
    ** Compile up to <bytes> bytes of the supplied SQL string <sql> using
    ** database handle <DB>. The parameter <tailval> is the name of a global
    ** variable that is set to the unused portion of <sql> (if any). A
    ** STMT handle is returned.
    */
    //static int test_prepare16_v2(
    // object clientdata,
    // Tcl_Interp interp,
    // int objc,
    // Tcl_Obj[] objv
    //){
#if !SQLITE_OMIT_UTF16
// sqlite3 db=null;
// string zSql;
// string zTail = 0;
// Tcl_Obj pTail = 0;
// sqlite3_stmt pStmt = null;
// char zBuf[50];
// int rc;
// int bytes; /* The integer specified as arg 3 */
// int objlen; /* The byte-array length of arg 2 */

// if( objc!=5 && objc!=4 ){
// TCL.Tcl_AppendResult(interp, "wrong # args: should be \"",
// TCL.Tcl_GetString(objv[0]), " DB sql bytes ?tailvar?", 0);
// return TCL.TCL_ERROR;
// }
// if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), out db) !=0) return TCL.TCL_ERROR;
// zSql = TCL.Tcl_GetByteArrayFromObj(objv[2], out objlen);
// if( TCL.Tcl_GetIntFromObj(interp, objv[3], out bytes) ) return TCL.TCL_ERROR;

// rc = sqlite3_prepare16_v2(db, zSql, bytes, pStmt,objc>=5 ? &zTail : 0);
// if( sqlite3TestErrCode(interp, db, rc) ) return TCL.TCL_ERROR;
// if( rc !=0){
// return TCL.TCL_ERROR;
// }

if( objc>=5 ){
if( zTail ){
objlen = objlen - ((u8 )zTail-(u8 )zSql);
}else{
objlen = 0;
}
pTail = TCL.Tcl_NewByteArrayObj((u8 )zTail, objlen);
TCL.Tcl_IncrRefCount(pTail);
Tcl_ObjSetVar2(interp, objv[4], 0, pTail, 0);
TCL.Tcl_DecrRefCount(pTail);
// }

// if( pStmt ){
// if( sqlite3TestMakePointerStr(interp, zBuf, pStmt) ) return TCL.TCL_ERROR;
// }
// TCL.Tcl_AppendResult(interp, zBuf);
#endif // * SQLITE_OMIT_UTF16 */
    // return TCL.TCL_OK;
    //}

    /*
    ** Usage: sqlite3_open filename ?options-list?
    */
    static int test_open(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      string zFilename;
      SqliteDb db = new SqliteDb();
      int rc;
      StringBuilder zBuf = new StringBuilder( 100 );
      if ( objc != 3 && objc != 2 && objc != 1 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " filename options-list" );
        return TCL.TCL_ERROR;
      }

      zFilename = objc > 1 ? TCL.Tcl_GetString( objv[1] ) : null;
      rc = sqlite3_open( zFilename, out db.db );

      if ( sqlite3TestMakePointerStr( interp, zBuf, db ) != TCL.TCL_OK )
        return TCL.TCL_ERROR;
      TCL.Tcl_AppendResult( interp, zBuf );
      return TCL.TCL_OK;
    }

    class OpenFlag
    {
      public string zFlag;
      public int flag;

      public OpenFlag( string zFlag, int flag )
      {
        this.zFlag = zFlag;
        this.flag = flag;
      }
    }
    /*
    ** Usage: sqlite3_open_v2 FILENAME FLAGS VFS
    */
    static int test_open_v2(
        object clientdata,
        Tcl_Interp interp,
        int objc,
        Tcl_Obj[] objv
    )
    {
      string zFilename;
      string zVfs;
      int flags = 0;
      sqlite3 db = null;
      int rc;
      StringBuilder zBuf = new StringBuilder( 100 );

      int nFlag = 0;
      Tcl_Obj[] apFlag = null;
      int i;

      if ( objc != 4 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "FILENAME FLAGS VFS" );
        return TCL.TCL_ERROR;
      }
      zFilename = TCL.Tcl_GetString( objv[1] );
      zVfs = TCL.Tcl_GetString( objv[3] );
      if ( zVfs[0] == 0x00 )
        zVfs = null;

      rc = TCL.Tcl_ListObjGetElements( interp, objv[2], out nFlag, out apFlag ) ? TCL.TCL_OK : 1;
      if ( rc != TCL.TCL_OK )
        return rc;
      for ( i = 0; i < nFlag; i++ )
      {
        int iFlag;
        OpenFlag[] aFlag = new OpenFlag[] {
      new OpenFlag( "SQLITE_OPEN_READONLY", SQLITE_OPEN_READONLY ),
      new OpenFlag( "SQLITE_OPEN_READWRITE", SQLITE_OPEN_READWRITE ),
      new OpenFlag( "SQLITE_OPEN_CREATE", SQLITE_OPEN_CREATE ),
      new OpenFlag( "SQLITE_OPEN_DELETEONCLOSE", SQLITE_OPEN_DELETEONCLOSE ),
      new OpenFlag( "SQLITE_OPEN_EXCLUSIVE", SQLITE_OPEN_EXCLUSIVE ),
      new OpenFlag( "SQLITE_OPEN_AUTOPROXY", SQLITE_OPEN_AUTOPROXY ),
      new OpenFlag( "SQLITE_OPEN_MAIN_DB", SQLITE_OPEN_MAIN_DB ),
      new OpenFlag( "SQLITE_OPEN_TEMP_DB", SQLITE_OPEN_TEMP_DB ),
      new OpenFlag( "SQLITE_OPEN_TRANSIENT_DB", SQLITE_OPEN_TRANSIENT_DB ),
      new OpenFlag( "SQLITE_OPEN_MAIN_JOURNAL", SQLITE_OPEN_MAIN_JOURNAL ),
      new OpenFlag( "SQLITE_OPEN_TEMP_JOURNAL", SQLITE_OPEN_TEMP_JOURNAL ),
      new OpenFlag( "SQLITE_OPEN_SUBJOURNAL", SQLITE_OPEN_SUBJOURNAL ),
      new OpenFlag( "SQLITE_OPEN_MASTER_JOURNAL", SQLITE_OPEN_MASTER_JOURNAL ),
      new OpenFlag( "SQLITE_OPEN_NOMUTEX", SQLITE_OPEN_NOMUTEX ),
      new OpenFlag( "SQLITE_OPEN_FULLMUTEX", SQLITE_OPEN_FULLMUTEX ),
      new OpenFlag( "SQLITE_OPEN_SHAREDCACHE", SQLITE_OPEN_SHAREDCACHE ),
      new OpenFlag( "SQLITE_OPEN_PRIVATECACHE", SQLITE_OPEN_PRIVATECACHE ),
      new OpenFlag( "SQLITE_OPEN_WAL", SQLITE_OPEN_WAL ),
      new OpenFlag( "SQLITE_OPEN_URI", SQLITE_OPEN_URI ),
      new OpenFlag( null, 0 )
    };
        //rc = TCL.Tcl_GetIndexFromObjStruct( interp, apFlag[i], aFlag, sizeof( aFlag[0] ), 
        //       "flag", 0, ref iFlag    );

        for ( iFlag = 0; iFlag < aFlag.Length && ( aFlag[iFlag].zFlag != objv[4].ToString() ); iFlag++ )
        {
        }
        if ( iFlag >= aFlag.Length )
          return TCL.TCL_ERROR;
        flags |= aFlag[iFlag].flag;
      }

      rc = sqlite3_open_v2( zFilename, out db, flags, zVfs );
      if ( sqlite3TestMakePointerStr( interp, zBuf, db ) != 0 )
        return TCL.TCL_ERROR;
      TCL.Tcl_AppendResult( interp, zBuf, 0 );
      return TCL.TCL_OK;
    }
    /*
    ** Usage: sqlite3_open16 filename options
    */
    //static int test_open16(
    // object clientdata,
    // Tcl_Interp interp,
    // int objc,
    // Tcl_Obj[] objv
    //){
#if !SQLITE_OMIT_UTF16
// string zFilename;
// sqlite3 db=null;
// int rc;
// char zBuf[100];

// if( objc!=3 ){
// TCL.Tcl_AppendResult(interp, "wrong # args: should be \"",
// TCL.Tcl_GetString(objv[0]), " filename options-list", 0);
// return TCL.TCL_ERROR;
// }

// zFilename = TCL.Tcl_GetByteArrayFromObj(objv[1], 0);
// rc = sqlite3_open16(zFilename, ref db);

// if ( sqlite3TestMakePointerStr( interp, zBuf, db ) != TCL.TCL_OK ) return TCL.TCL_ERROR;
// TCL.Tcl_AppendResult(interp, zBuf);
#endif // * SQLITE_OMIT_UTF16 */
    // return TCL.TCL_OK;
    //}

    /*
    ** Usage: sqlite3_complete16 <UTF-16 string>
    **
    ** Return 1 if the supplied argument is a complete SQL statement, or zero
    ** otherwise.
    */
    //static int test_complete16(
    // object clientdata,
    // Tcl_Interp interp,
    // int objc,
    // Tcl_Obj[] objv
    //){
#if !SQLITE_OMIT_COMPLETE && !SQLITE_OMIT_UTF16
// string zBuf;

// if( objc!=2 ){
// TCL.Tcl_WrongNumArgs(interp, 1, objv, "<utf-16 sql>");
// return TCL.TCL_ERROR;
// }

// zBuf = (char)TCL.Tcl_GetByteArrayFromObj(objv[1], 0);
// TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewIntObj(sqlite3_complete16(zBuf)));
#endif // * SQLITE_OMIT_COMPLETE && SQLITE_OMIT_UTF16 */
    // return TCL.TCL_OK;
    //}

    /*
    ** Usage: sqlite3_step STMT
    **
    ** Advance the statement to the next row.
    */
    static int test_step(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      int rc;

      if ( objc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " STMT" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      rc = sqlite3_step( pStmt );

      /* if( rc!=SQLITE_DONE && rc!=SQLITE_ROW ) return TCL.TCL_ERROR; */
      TCL.Tcl_SetResult( interp, t1ErrorName( rc ), 0 );
      return TCL.TCL_OK;
    }

    static int test_sql(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;

      if ( objc != 2 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "STMT" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      TCL.Tcl_SetResult( interp, sqlite3_sql( pStmt ), TCL.TCL_VOLATILE );
      return TCL.TCL_OK;
    }


    /*
    ** Usage: sqlite3_column_count STMT
    **
    ** Return the number of columns returned by the sql statement STMT.
    */
    static int test_column_count(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;

      if ( objc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " STMT column" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;

      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( sqlite3_column_count( pStmt ) ) );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_column_type STMT column
    **
    ** Return the type of the data in column 'column' of the current row.
    */
    static int test_column_type(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      int col = 0;
      int tp;

      if ( objc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " STMT column" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out col ) )
        return TCL.TCL_ERROR;

      tp = sqlite3_column_type( pStmt, col );
      switch ( tp )
      {
        case SQLITE_INTEGER:
          TCL.Tcl_SetResult( interp, "INTEGER", TCL.TCL_STATIC );
          break;
        case SQLITE_NULL:
          TCL.Tcl_SetResult( interp, "NULL", TCL.TCL_STATIC );
          break;
        case SQLITE_FLOAT:
          TCL.Tcl_SetResult( interp, "FLOAT", TCL.TCL_STATIC );
          break;
        case SQLITE_TEXT:
          TCL.Tcl_SetResult( interp, "TEXT", TCL.TCL_STATIC );
          break;
        case SQLITE_BLOB:
          TCL.Tcl_SetResult( interp, "BLOB", TCL.TCL_STATIC );
          break;
        default:
          Debugger.Break();
          break;
      }

      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_column_int64 STMT column
    **
    ** Return the data in column 'column' of the current row cast as an
    ** wide (64-bit) integer.
    */
    static int test_column_int64(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = new sqlite3_stmt();
      int col = 0;
      i64 iVal;

      if ( objc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " STMT column" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != TCL.TCL_OK )
        return TCL.TCL_ERROR;
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out col ) )
        return TCL.TCL_ERROR;

      iVal = sqlite3_column_int64( pStmt, col );
      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewWideIntObj( iVal ) );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_column_blob STMT column
    */
    static int test_column_blob(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = new sqlite3_stmt();
      int col = 0;

      int len;
      byte[] pBlob;

      if ( objc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " STMT column" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != TCL.TCL_OK )
        return TCL.TCL_ERROR;
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out col ) )
        return TCL.TCL_ERROR;

      len = sqlite3_column_bytes( pStmt, col );
      pBlob = sqlite3_column_blob( pStmt, col );
      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewByteArrayObj( pBlob, len ) );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_column_double STMT column
    **
    ** Return the data in column 'column' of the current row cast as a double.
    */
    static int test_column_double(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = new sqlite3_stmt();
      int col = 0;
      double rVal;

      if ( objc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " STMT column" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != TCL.TCL_OK )
        return TCL.TCL_ERROR;
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out col ) )
        return TCL.TCL_ERROR;

      rVal = sqlite3_column_double( pStmt, col );
      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewDoubleObj( rVal ) );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_data_count STMT
    **
    ** Return the number of columns returned by the sql statement STMT.
    */
    static int test_data_count(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;

      if ( objc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " STMT column" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != TCL.TCL_OK )
        return TCL.TCL_ERROR;

      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( sqlite3_data_count( pStmt ) ) );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_column_text STMT column
    **
    ** Usage: sqlite3_column_decltype STMT column
    **
    ** Usage: sqlite3_column_name STMT column
    */
    static int test_stmt_utf8(
    object clientdata, /* Pointer to SQLite API function to be invoke */
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      int col = 0;
      dxColumn xFunc;//string (*xFunc)(sqlite3_stmt*, int);
      string zRet;

      xFunc = (dxColumn)clientdata; //(string ()(sqlite3_stmt*, int))clientData;
      if ( objc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " STMT column" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out col ) )
        return TCL.TCL_ERROR;
      zRet = (string)xFunc( pStmt, col );
      if ( zRet != null )
      {
        TCL.Tcl_SetResult( interp, zRet, 0 );
      }
      return TCL.TCL_OK;
    }

    static int test_global_recover(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
#if !SQLITE_OMIT_DEPRECATED
int rc;
if ( objc != 1 )
{
TCL.Tcl_WrongNumArgs( interp, 1, objv, "" );
return TCL.TCL_ERROR;
}
rc = sqlite3_global_recover();
TCL.Tcl_SetResult( interp, t1ErrorName( rc ), TCL.TCL_STATIC );
#else
      TCL.Tcl_SetResult( interp, t1ErrorName( SQLITE_OK ), TCL.TCL_STATIC );
#endif
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_column_text STMT column
    **
    ** Usage: sqlite3_column_decltype STMT column
    **
    ** Usage: sqlite3_column_name STMT column
    */
    //static int test_stmt_utf16(
    // object clientdata, /* Pointer to SQLite API function to be invoked */
    // Tcl_Interp interp,
    // int objc,
    // Tcl_Obj[] objv
    //){
#if !SQLITE_OMIT_UTF16
// sqlite3_stmt pStmt;
// int col;
// Tcl_Obj pRet;
// string zName16;
// const void *(*xFunc)(sqlite3_stmt*, int);

xFunc = (dxColumn)clientdata; //(string ()(sqlite3_stmt*, int))clientData;
// if( objc!=3 ){
// TCL.Tcl_AppendResult(interp, "wrong # args: should be \"",
// TCL.Tcl_GetString(objv[0]), " STMT column", 0);
// return TCL.TCL_ERROR;
// }

// if( getStmtPointer(interp, TCL.Tcl_GetString(objv[1]), pStmt) ) return TCL.TCL_ERROR;
// if( TCL.Tcl_GetIntFromObj(interp, objv[2], out col) ) return TCL.TCL_ERROR;

// zName16 = xFunc(pStmt, col);
// if( zName16 ){
int n;
string z = zName16;
for(n=0; z[n] || z[n+1]; n+=2){}
pRet = TCL.Tcl_NewByteArrayObj(zName16, n+2);
// TCL.Tcl_SetObjResult(interp, pRet);
// }
#endif // * SQLITE_OMIT_UTF16 */

    // return TCL.TCL_OK;
    //}

    /*
    ** Usage: sqlite3_column_int STMT column
    **
    ** Usage: sqlite3_column_bytes STMT column
    **
    ** Usage: sqlite3_column_bytes16 STMT column
    **
    */
    static int test_stmt_int(
    object clientdata, /* Pointer to SQLite API function to be invoked */
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_stmt pStmt = null;
      int col = 0;
      dxColumn_I xFunc;//(sqlite3_stmt*, int) ;

      xFunc = (dxColumn_I)clientdata; //(int ()(sqlite3_stmt*, int))clientData;
      if ( objc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetString( objv[0] ), " STMT column" );
        return TCL.TCL_ERROR;
      }

      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out col ) )
        return TCL.TCL_ERROR;

      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( xFunc( pStmt, col ) ) );
      return TCL.TCL_OK;
    }


    /*
    ** Usage: sqlite_set_magic DB MAGIC-NUMBER
    **
    ** Set the db.magic value. This is used to test error recovery logic.
    */
    static int sqlite_set_magic(
    object clientdata, /* Pointer to SQLite API function to be invoked */
    Tcl_Interp interp,
    int argc,
    Tcl_Obj[] argv
    )
    {
      sqlite3 db = null;
      if ( argc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " DB MAGIC" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      if ( argv[2].ToString() == "SQLITE_MAGIC_OPEN" )
      {
        db.magic = SQLITE_MAGIC_OPEN;
      }
      else if ( argv[2].ToString() == "SQLITE_MAGIC_CLOSED" )
      {
        db.magic = SQLITE_MAGIC_CLOSED;
      }
      else if ( argv[2].ToString() == "SQLITE_MAGIC_BUSY" )
      {
        db.magic = SQLITE_MAGIC_BUSY;
      }
      else if ( argv[2].ToString() == "SQLITE_MAGIC_ERROR" )
      {
        db.magic = SQLITE_MAGIC_ERROR;
      }
      else if ( TCL.Tcl_GetInt( interp, argv[2], out db.magic ) )
      {
        return TCL.TCL_ERROR;
      }
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_interrupt DB
    **
    ** Trigger an interrupt on DB
    */
    static int test_interrupt(
     object clientdata,
    Tcl_Interp interp,
    int argc,
    Tcl_Obj[] argv )
    {
      sqlite3 db = null;
      if ( argc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0], " DB" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      sqlite3_interrupt( db );
      return TCL.TCL_OK;
    }

    //static u8 *sqlite3_stack_baseline = 0;

    /*
    ** Fill the stack with a known bitpattern.
    */
    //static void prepStack(void){
    // int i;
    // u32 bigBuf[65536];
    // for(i=0; i<sizeof(bigBuf); i++) bigBuf[i] = 0xdeadbeef;
    // sqlite3_stack_baseline = (u8)&bigBuf[65536];
    //}

    /*
    ** Get the current stack depth. Used for debugging only.
    */
    //u64 sqlite3StackDepth(void){
    // u8 x;
    // return (u64)(sqlite3_stack_baseline - &x);
    //}

    /*
    ** Usage: sqlite3_stack_used DB SQL
    **
    ** Try to measure the amount of stack space used by a call to sqlite3_exec
    */
    //static int test_stack_used(
    // object clientdata,
    // Tcl_Interp interp,
    // int argc,
    // char **argv
    //){
    // sqlite3 db=null;
    // int i;
    // if( argc!=3 ){
    // TCL.Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
    // " DB SQL", 0);
    // return TCL.TCL_ERROR;
    // }
    // if( getDbPointer(interp, argv[1].ToString(), out db) !=0) return TCL.TCL_ERROR;
    // prepStack();
    // (void)sqlite3_exec(db, argv[2], 0, 0, 0);
    // for(i=65535; i>=0 && ((u32)sqlite3_stack_baseline)[-i]==0xdeadbeef; i--){}
    // TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewIntObj(i*4));
    // return TCL.TCL_OK;
    //}

    /*
    ** Usage: sqlite_delete_function DB function-name
    **
    ** Delete the user function 'function-name' from database handle DB. It
    ** is assumed that the user function was created as UTF8, any number of
    ** arguments (the way the TCL interface does it).
    */
    static int delete_function(
    object clientdata,
    Tcl_Interp interp,
    int argc,
    Tcl_Obj[] argv
    )
    {
      int rc;
      sqlite3 db = null;
      if ( argc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " DB function-name", null );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      rc = sqlite3_create_function( db, argv[2].ToString(), -1, SQLITE_UTF8, null, null, null, null );
      TCL.Tcl_SetResult( interp, t1ErrorName( rc ), TCL.TCL_STATIC );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite_delete_collation DB collation-name
    **
    ** Delete the collation sequence 'collation-name' from database handle
    ** DB. It is assumed that the collation sequence was created as UTF8 (the
    ** way the TCL interface does it).
    */
    static int delete_collation(
    object clientdata,
    Tcl_Interp interp,
    int argc,
    Tcl_Obj[] argv
    )
    {
      int rc;
      sqlite3 db = null;
      if ( argc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " DB function-name", null );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      rc = sqlite3_create_collation( db, argv[2].ToString(), SQLITE_UTF8, null, null );
      TCL.Tcl_SetResult( interp, t1ErrorName( rc ), TCL.TCL_STATIC );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_get_autocommit DB
    **
    ** Return true if the database DB is currently in auto-commit mode.
    ** Return false if not.
    */
    static int get_autocommit(
    object clientdata,
    Tcl_Interp interp,
    int argc,
    Tcl_Obj[] argv
    )
    {
      StringBuilder zBuf = new StringBuilder( 30 );
      sqlite3 db = null;
      if ( argc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " DB" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      sqlite3_snprintf( 30, zBuf, "%d", sqlite3_get_autocommit( db ) );
      TCL.Tcl_AppendResult( interp, zBuf );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_busy_timeout DB MS
    **
    ** Set the busy timeout. This is more easily done using the timeout
    ** method of the TCL interface. But we need a way to test the case
    ** where it returns SQLITE_MISUSE.
    */
    static int test_busy_timeout(
    object clientdata,
    Tcl_Interp interp,
    int argc,
    Tcl_Obj[] argv
    )
    {
      int rc, ms = 0;
      sqlite3 db = null;
      if ( argc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
        " DB" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
        return TCL.TCL_ERROR;
      if ( TCL.Tcl_GetInt( interp, argv[2], out ms ) )
        return TCL.TCL_ERROR;
      rc = sqlite3_busy_timeout( db, ms );
      TCL.Tcl_AppendResult( interp, sqlite3TestErrorName( rc ) );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: tcl_variable_type VARIABLENAME
    **
    ** Return the name of the internal representation for the
    ** value of the given variable.
    */
    static int tcl_variable_type(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      Tcl_Obj pVar;
      if ( objc != 2 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "VARIABLE" );
        return TCL.TCL_ERROR;
      }
      pVar = TCL.Tcl_GetVar2Ex( interp, TCL.Tcl_GetString( objv[1] ), null, (TCL.VarFlag)TCL.TCL_LEAVE_ERR_MSG );
      if ( pVar == null )
        return TCL.TCL_ERROR;
      if ( pVar.typePtr != "" )
      {
        TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewStringObj( pVar.typePtr, -1 ) );
      }
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_release_memory ?N?
    **
    ** Attempt to release memory currently held but not actually required.
    ** The integer N is the number of bytes we are trying to release. The
    ** return value is the amount of memory actually released.
    */
    static int test_release_memory(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
#if SQLITE_ENABLE_MEMORY_MANAGEMENT && !SQLITE_OMIT_DISKIO
int N;
int amt;
if( objc!=1 && objc!=2 ){
TCL.Tcl_WrongNumArgs(interp, 1, objv, "?N?");
return TCL.TCL_ERROR;
}
if( objc==2 ){
if( TCL.Tcl_GetIntFromObj(interp, objv[1], out N) ) return TCL.TCL_ERROR;
}else{
N = -1;
}
amt = sqlite3_release_memory(N);
TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewIntObj(amt));
#endif
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_soft_heap_limit ?N?
    **
    ** Query or set the soft heap limit for the current thread. The
    ** limit is only changed if the N is present. The previous limit
    ** is returned.
    */
    static int test_soft_heap_limit(
    object clientdata,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      sqlite3_int64 amt;
      sqlite3_int64 N = -1;
      if ( objc != 1 && objc != 2 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "?N?" );
        return TCL.TCL_ERROR;
      }
      if ( objc == 2 )
      {
        if ( TCL.Tcl_GetWideIntFromObj( interp, objv[1], out N ) )
          return TCL.TCL_ERROR;
      }
      amt = sqlite3_soft_heap_limit64( N );
      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewWideIntObj( amt ) );
      return TCL.TCL_OK;
    }

    /*
    ** Usage: sqlite3_thread_cleanup
    **
    ** Call the sqlite3_thread_cleanup API.
    */
    //static int test_thread_cleanup(
    // object clientdata,
    // Tcl_Interp interp,
    // int objc,
    // Tcl_Obj[] objv
    //){
    // sqlite3_thread_cleanup();
    // return TCL.TCL_OK;
    //}


    /*
    ** Usage: sqlite3_pager_refcounts DB
    **
    ** Return a list of numbers which are the PagerRefcount for all
    ** pagers on each database connection.
    */
    //static int test_pager_refcounts(
    // object clientdata,
    // Tcl_Interp interp,
    // int objc,
    // Tcl_Obj[] objv
    //){
    // sqlite3 db=null;
    // int i;
    // int v, *a;
    // Tcl_Obj pResult;

    // if( objc!=2 ){
    // TCL.Tcl_AppendResult(interp, "wrong # args: should be \"",
    // TCL.Tcl_GetStringFromObj(objv[0], 0), " DB", 0);
    // return TCL.TCL_ERROR;
    // }
    // if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), out db) !=0) return TCL.TCL_ERROR;
    // pResult = TCL.Tcl_NewObj();
    // for(i=0; i<db.nDb; i++){
    // if( db.aDb[i].pBt==null ){
    // v = -1;
    // }else{
    // sqlite3_mutex_enter(db.mutex);
    // a = sqlite3PagerStats(sqlite3BtreePager(db.aDb[i].pBt));
    // v = a[0];
    // sqlite3_mutex_leave(db.mutex);
    // }
    // TCL.Tcl_ListObjAppendElement(0, pResult, TCL.Tcl_NewIntObj(v));
    // }
    // TCL.Tcl_SetObjResult(interp, pResult);
    // return TCL.TCL_OK;
    //}


    /*
    ** tclcmd: working_64bit_int
    **
    ** Some TCL builds (ex: cygwin) do not support 64-bit integers. This
    ** leads to a number of test failures. The present command checks the
    ** TCL build to see whether or not it supports 64-bit integers. It
    ** returns TRUE if it does and FALSE if not.
    **
    ** This command is used to warn users that their TCL build is defective
    ** and that the errors they are seeing in the test scripts might be
    ** a result of their defective TCL rather than problems in SQLite.
    */
    static int working_64bit_int(
    object clientdata, /* Pointer to sqlite3_enable_XXX function */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      Tcl_Obj pTestObj;
      int working = 0;

      pTestObj = TCL.Tcl_NewWideIntObj( 1000000 * (i64)1234567890 );
      working = ( TCL.Tcl_GetString( pTestObj ) == "1234567890000000" ) ? 1 : 0;
      TCL.Tcl_DecrRefCount( ref pTestObj );
      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewBooleanObj( working ) );
      return TCL.TCL_OK;
    }


    /*
    ** tclcmd: vfs_unlink_test
    **
    ** This TCL command unregisters the primary VFS and then registers
    ** it back again. This is used to test the ability to register a
    ** VFS when none are previously registered, and the ability to
    ** unregister the only available VFS. Ticket #2738
    */
    static int vfs_unlink_test(
    object clientdata, /* Pointer to sqlite3_enable_XXX function */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      int i;
      sqlite3_vfs pMain;
      sqlite3_vfs one = new sqlite3_vfs();
      sqlite3_vfs two = new sqlite3_vfs();

      sqlite3_vfs_unregister( null ); /* Unregister of NULL is harmless */
      one.zName = "__one";
      two.zName = "__two";

      /* Calling sqlite3_vfs_register with 2nd argument of 0 does not
      ** change the default VFS
      */
      pMain = sqlite3_vfs_find( null );
      sqlite3_vfs_register( one, 0 );
      Debug.Assert( pMain == null || pMain == sqlite3_vfs_find( null ) );
      sqlite3_vfs_register( two, 0 );
      Debug.Assert( pMain == null || pMain == sqlite3_vfs_find( null ) );

      /* We can find a VFS by its name */
      Debug.Assert( sqlite3_vfs_find( "__one" ) == one );
      Debug.Assert( sqlite3_vfs_find( "__two" ) == two );

      /* Calling sqlite_vfs_register with non-zero second parameter changes the
      ** default VFS, even if the 1st parameter is an existig VFS that is
      ** previously registered as the non-default.
      */
      sqlite3_vfs_register( one, 1 );
      Debug.Assert( sqlite3_vfs_find( "__one" ) == one );
      Debug.Assert( sqlite3_vfs_find( "__two" ) == two );
      Debug.Assert( sqlite3_vfs_find( null ) == one );
      sqlite3_vfs_register( two, 1 );
      Debug.Assert( sqlite3_vfs_find( "__one" ) == one );
      Debug.Assert( sqlite3_vfs_find( "__two" ) == two );
      Debug.Assert( sqlite3_vfs_find( null ) == two );
      if ( pMain != null )
      {
        sqlite3_vfs_register( pMain, 1 );
        Debug.Assert( sqlite3_vfs_find( "__one" ) == one );
        Debug.Assert( sqlite3_vfs_find( "__two" ) == two );
        Debug.Assert( sqlite3_vfs_find( null ) == pMain );
      }

      /* Unlink the default VFS. Repeat until there are no more VFSes
      ** registered.
      */
      for ( i = 0; i < apVfs.Length; i++ )
      {//sizeof(apVfs)/sizeof(apVfs[0]); i++){
        apVfs[i] = sqlite3_vfs_find( null );
        if ( apVfs[i] != null )
        {
          Debug.Assert( apVfs[i] == sqlite3_vfs_find( apVfs[i].zName ) );
          sqlite3_vfs_unregister( apVfs[i] );
          Debug.Assert( null == sqlite3_vfs_find( apVfs[i].zName ) );
        }
      }
      Debug.Assert( null == sqlite3_vfs_find( null ) );


      /* Register the main VFS as non-default (will be made default, since
      ** it'll be the only one in existence).
      */
      sqlite3_vfs_register( pMain, 0 );
      Debug.Assert( sqlite3_vfs_find( null ) == pMain );

      /* Un-register the main VFS again to restore an empty VFS list */
      sqlite3_vfs_unregister( pMain );
      Debug.Assert( null == sqlite3_vfs_find( null ) );

      /* Relink all VFSes in reverse order. */
      for ( i = apVfs.Length - 1; i >= 0; i-- )
      {//sizeof(apVfs)/sizeof(apVfs[0])-1; i>=0; i--){
        if ( apVfs[i] != null )
        {
          sqlite3_vfs_register( apVfs[i], 1 );
          Debug.Assert( apVfs[i] == sqlite3_vfs_find( null ) );
          Debug.Assert( apVfs[i] == sqlite3_vfs_find( apVfs[i].zName ) );
        }
      }

      /* Unregister out sample VFSes. */
      sqlite3_vfs_unregister( one );
      sqlite3_vfs_unregister( two );

      /* Unregistering a VFS that is not currently registered is harmless */
      sqlite3_vfs_unregister( one );
      sqlite3_vfs_unregister( two );
      Debug.Assert( sqlite3_vfs_find( "__one" ) == null );
      Debug.Assert( sqlite3_vfs_find( "__two" ) == null );

      /* We should be left with the original default VFS back as the
      ** original */
      Debug.Assert( sqlite3_vfs_find( null ) == pMain );

      return TCL.TCL_OK;
    }

    /*
    ** tclcmd: vfs_initfail_test
    **
    ** This TCL command attempts to vfs_find and vfs_register when the
    ** sqlite3_initialize() interface is failing. All calls should fail.
    */
    //static int vfs_initfail_test(
    // ClientData clientData, /* Pointer to sqlite3_enable_XXX function */
    // Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    // int objc, /* Number of arguments */
    // Tcl_Obj[] objv /* Command arguments */
    //){
    // sqlite3_vfs one;
    // one.zName = "__one";

    // if( sqlite3_vfs_find(0) ) return TCL.TCL_ERROR;
    // sqlite3_vfs_register(&one, 0);
    // if( sqlite3_vfs_find(0) ) return TCL.TCL_ERROR;
    // sqlite3_vfs_register(&one, 1);
    // if( sqlite3_vfs_find(0) ) return TCL.TCL_ERROR;
    // return TCL.TCL_OK;
    //}


    /*
    ** Saved VFSes
    */
    static sqlite3_vfs[] apVfs = new sqlite3_vfs[20];
    static int nVfs = 0;

    /*
    ** tclcmd: vfs_unregister_all
    **
    ** Unregister all VFSes.
    */
    static int vfs_unregister_all(
    object clientdata, /* Pointer to sqlite3_enable_XXX function */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      int i;
      for ( i = 0; i < apVfs.Length; i++ )
      {
        apVfs[i] = sqlite3_vfs_find( null );
        if ( apVfs[i] == null )
          break;
        sqlite3_vfs_unregister( apVfs[i] );
      }
      nVfs = i;
      return TCL.TCL_OK;
    }

    /*
    ** tclcmd: vfs_reregister_all
    **
    ** Restore all VFSes that were removed using vfs_unregister_all
    */
    static int vfs_reregister_all(
    object clientdata, /* Pointer to sqlite3_enable_XXX function */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      int i;
      for ( i = 0; i < nVfs; i++ )
      {
        sqlite3_vfs_register( apVfs[i], i == 0 ? 1 : 0 );
      }
      return TCL.TCL_OK;
    }


    /*
    ** tclcmd: file_control_test DB
    **
    ** This TCL command runs the sqlite3_file_control interface and
    ** verifies correct operation of the same.
    */
    static int file_control_test(
    object clientdata, /* Pointer to sqlite3_enable_XXX function */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      sqlite3_int64 iArg = 0;
      sqlite3 db = null;
      int rc;

      if ( objc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetStringFromObj( objv[0], 0 ), " DB" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
        return TCL.TCL_ERROR;
      rc = sqlite3_file_control( db, null, 0, ref iArg );
      Debug.Assert( rc == SQLITE_NOTFOUND );
      rc = sqlite3_file_control( db, "notadatabase", SQLITE_FCNTL_LOCKSTATE, ref iArg );
      Debug.Assert( rc == SQLITE_ERROR );
      rc = sqlite3_file_control( db, "main", -1, ref iArg );
      Debug.Assert( rc == SQLITE_NOTFOUND );
      rc = sqlite3_file_control( db, "temp", -1, ref iArg );
      Debug.Assert( rc == SQLITE_NOTFOUND || rc == SQLITE_ERROR );
      return TCL.TCL_OK;
    }


    /*
    ** tclcmd: file_control_lasterrno_test DB
    **
    ** This TCL command runs the sqlite3_file_control interface and
    ** verifies correct operation of the SQLITE_LAST_ERRNO verb.
    */
    static int file_control_lasterrno_test(
    ClientData clientData, /* Pointer to sqlite3_enable_XXX function */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      sqlite3_int64 iArg = 0;
      sqlite3 db = null;
      int rc;

      if ( objc != 2 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetStringFromObj( objv[0], 0 ), " DB" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
      {
        return TCL.TCL_ERROR;
      }
      rc = sqlite3_file_control( db, null, SQLITE_LAST_ERRNO, ref iArg );
      if ( rc != 0 )
      {
        TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( rc ) );
        return TCL.TCL_ERROR;
      }
      if ( iArg != 0 )
      {
        TCL.Tcl_AppendResult( interp, "Unexpected non-zero errno: ", iArg.ToString(), "" );
        //TCL.Tcl_GetStringFromObj(TCL.Tcl_NewIntObj(iArg), 0), " ", 0);
        return TCL.TCL_ERROR;
      }
      return TCL.TCL_OK;
    }


    /*
    ** tclcmd: file_control_chunksize_test DB DBNAME SIZE
    **
    ** This TCL command runs the sqlite3_file_control interface and
    ** verifies correct operation of the SQLITE_GET_LOCKPROXYFILE and
    ** SQLITE_SET_LOCKPROXYFILE verbs.
    */
    static int file_control_chunksize_test(
    ClientData clientData, /* Pointer to sqlite3_enable_XXX function */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      int nSize = 0; /* New chunk size */
      string zDb; /* Db name ("main", "temp" etc.) */
      sqlite3 db = null; /* Database handle */
      int rc; /* file_control() return code */

      if ( objc != 4 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB DBNAME SIZE" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0
      || TCL.Tcl_GetIntFromObj( interp, objv[3], out nSize ) != 0
      )
      {
        return TCL.TCL_ERROR;
      }
      zDb = TCL.Tcl_GetString( objv[2] );
      if ( zDb == "" )
        zDb = null;

      i64 iSize = 0;
      rc = sqlite3_file_control( db, zDb, SQLITE_FCNTL_CHUNK_SIZE, ref iSize );
      nSize = (int)iSize;

      if ( rc != 0 )
      {
        TCL.Tcl_SetResult( interp, sqlite3TestErrorName( rc ), TCL.TCL_STATIC );
        return TCL.TCL_ERROR;
      }
      return TCL.TCL_OK;
    }



    /*
    ** tclcmd:   file_control_sizehint_test DB DBNAME SIZE
    **
    ** This TCL command runs the sqlite3_file_control interface and
    ** verifies correct operation of the SQLITE_GET_LOCKPROXYFILE and
    ** SQLITE_SET_LOCKPROXYFILE verbs.
    */
    static int file_control_sizehint_test(
        ClientData clientData, /* Pointer to sqlite3_enable_XXX function */
        Tcl_Interp interp, /* The TCL interpreter that invoked this command */
        int objc, /* Number of arguments */
        Tcl_Obj[] objv /* Command arguments */
    )
    {
      sqlite3_int64 nSize = 0;         /* Hinted size */
      string zDb;                      /* Db name ("main", "temp" etc.) */
      sqlite3 db = null;               /* Database handle */
      int rc;                          /* file_control() return code */

      if ( objc != 4 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB DBNAME SIZE" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0
       || TCL.Tcl_GetWideIntFromObj( interp, objv[3], out nSize )
      )
      {
        return TCL.TCL_ERROR;
      }
      zDb = TCL.Tcl_GetString( objv[2] );
      if ( zDb[0] == '\0' )
        zDb = null;

      rc = sqlite3_file_control( db, zDb, SQLITE_FCNTL_SIZE_HINT, ref nSize );
      if ( rc != 0 )
      {
        TCL.Tcl_SetResult( interp, sqlite3TestErrorName( rc ), TCL.TCL_STATIC );
        return TCL.TCL_ERROR;
      }
      return TCL.TCL_OK;
    }

    /*
    ** tclcmd: file_control_lockproxy_test DB PWD
    **
    ** This TCL command runs the sqlite3_file_control interface and
    ** verifies correct operation of the SQLITE_GET_LOCKPROXYFILE and
    ** SQLITE_SET_LOCKPROXYFILE verbs.
    */
    static int file_control_lockproxy_test(
    ClientData clientData, /* Pointer to sqlite3_enable_XXX function */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      sqlite3 db = null;
      string zPwd;
      int nPwd = 0;

      if ( objc != 3 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetStringFromObj( objv[0], 0 ), " DB PWD" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
      {
        return TCL.TCL_ERROR;
      }
      zPwd = TCL.Tcl_GetStringFromObj( objv[2], out nPwd );

      //#if !(SQLITE_ENABLE_LOCKING_STYLE) && (__APPLE__)
      //{
      // char *testPath;
      // int rc;
      // char proxyPath[400];

      // if( sizeof(proxyPath)<nPwd+20 ){
      // TCL.Tcl_AppendResult(interp, "PWD too big", (void)0);
      // return TCL.TCL_ERROR;
      // }
      // sprintf(proxyPath, "%s/test.proxy", zPwd);
      // rc = sqlite3_file_control(db, NULL, SQLITE_SET_LOCKPROXYFILE, proxyPath);
      // if( rc ){
      // TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewIntObj(rc)); 
      // return TCL.TCL_ERROR;
      // }
      // rc = sqlite3_file_control(db, NULL, SQLITE_GET_LOCKPROXYFILE, &testPath);
      // if( strncmp(proxyPath,testPath,11) ){
      // TCL.Tcl_AppendResult(interp, "Lock proxy file did not match the "
      // "previously assigned value", 0);
      // return TCL.TCL_ERROR;
      // }
      // if( rc ){
      // TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewIntObj(rc));
      // return TCL.TCL_ERROR;
      // }
      // rc = sqlite3_file_control(db, NULL, SQLITE_SET_LOCKPROXYFILE, proxyPath);
      // if( rc ){
      // TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewIntObj(rc));
      // return TCL.TCL_ERROR;
      // }
      //}
      //#endif
      return TCL.TCL_OK;
    }

    /*
    ** tclcmd: sqlite3_vfs_list
    **
    ** Return a tcl list containing the names of all registered vfs's.
    */
    //static int vfs_list(
    // ClientData clientData, /* Pointer to sqlite3_enable_XXX function */
    // Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    // int objc, /* Number of arguments */
    // Tcl_Obj[] objv /* Command arguments */
    //){
    // sqlite3_vfs pVfs;
    // Tcl_Obj pRet = TCL.Tcl_NewObj();
    // if( objc!=1 ){
    // TCL.Tcl_WrongNumArgs(interp, 1, objv, "");
    // return TCL.TCL_ERROR;
    // }
    // for(pVfs=sqlite3_vfs_find(0); pVfs!=null; pVfs=pVfs.pNext){
    // TCL.Tcl_ListObjAppendElement(interp, pRet, TCL.Tcl_NewStringObj(pVfs.zName, -1));
    // }
    // TCL.Tcl_SetObjResult(interp, pRet);
    // return TCL.TCL_OK;
    //}

    /*
    ** tclcmd: sqlite3_limit DB ID VALUE
    **
    ** This TCL command runs the sqlite3_limit interface and
    ** verifies correct operation of the same.
    */
    struct _aID
    {
      public string zName;
      public int id;
      public _aID( string zName, int id )
      {
        this.zName = zName;
        this.id = id;
      }
    }

    static int test_limit(
    object clientdata, /* Pointer to sqlite3_enable_XXX function */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      sqlite3 db = null;
      int rc = 0;
      _aID[] aId = new _aID[] {
new _aID( "SQLITE_LIMIT_LENGTH", SQLITE_LIMIT_LENGTH ),
new _aID( "SQLITE_LIMIT_SQL_LENGTH", SQLITE_LIMIT_SQL_LENGTH ),
new _aID( "SQLITE_LIMIT_COLUMN", SQLITE_LIMIT_COLUMN ),
new _aID( "SQLITE_LIMIT_EXPR_DEPTH", SQLITE_LIMIT_EXPR_DEPTH ),
new _aID( "SQLITE_LIMIT_COMPOUND_SELECT", SQLITE_LIMIT_COMPOUND_SELECT ),
new _aID( "SQLITE_LIMIT_VDBE_OP", SQLITE_LIMIT_VDBE_OP ),
new _aID( "SQLITE_LIMIT_FUNCTION_ARG", SQLITE_LIMIT_FUNCTION_ARG ),
new _aID( "SQLITE_LIMIT_ATTACHED", SQLITE_LIMIT_ATTACHED ),
new _aID( "SQLITE_LIMIT_LIKE_PATTERN_LENGTH", SQLITE_LIMIT_LIKE_PATTERN_LENGTH ),
new _aID( "SQLITE_LIMIT_VARIABLE_NUMBER", SQLITE_LIMIT_VARIABLE_NUMBER ),
new _aID( "SQLITE_LIMIT_TRIGGER_DEPTH", SQLITE_LIMIT_TRIGGER_DEPTH ),

/* Out of range test cases */
new _aID( "SQLITE_LIMIT_TOOSMALL", -1 ),
new _aID( "SQLITE_LIMIT_TOOBIG", SQLITE_LIMIT_TRIGGER_DEPTH+1 ),
};
      int i, id = 0;
      int val = 0;
      string zId;

      if ( objc != 4 )
      {
        TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
        TCL.Tcl_GetStringFromObj( objv[0], 0 ), " DB ID VALUE" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
        return TCL.TCL_ERROR;
      zId = TCL.Tcl_GetString( objv[2] );
      for ( i = 0; i < aId.Length; i++ )
      {
        if ( zId == aId[i].zName )
        {
          id = aId[i].id;
          break;
        }
      }
      if ( i >= aId.Length )
      {
        TCL.Tcl_AppendResult( interp, "unknown limit type: ", zId, '\0' );
        return TCL.TCL_ERROR;
      }
      if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[3], out val ) )
        return TCL.TCL_ERROR;
      rc = sqlite3_limit( db, id, val );
      TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( rc ) );
      return TCL.TCL_OK;
    }

    /*
    ** tclcmd: save_prng_state
    **
    ** Save the state of the pseudo-random number generator.
    ** At the same time, verify that sqlite3_test_control works even when
    ** called with an out-of-range opcode.
    */
    static int save_prng_state(
    object clientdata, /* Pointer to sqlite3_enable_XXX function */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      int rc = sqlite3_test_control( 9999 );
      Debug.Assert( rc == 0 );
      rc = sqlite3_test_control( -1 );
      Debug.Assert( rc == 0 );
      sqlite3_test_control( SQLITE_TESTCTRL_PRNG_SAVE );
      return TCL.TCL_OK;
    }
    /*
    ** tclcmd: restore_prng_state
    */
    static int restore_prng_state(
    object clientdata, /* Pointer to sqlite3_enable_XXX function */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      sqlite3_test_control( SQLITE_TESTCTRL_PRNG_RESTORE );
      return TCL.TCL_OK;
    }
    /*
    ** tclcmd: reset_prng_state
    */
    static int reset_prng_state(
    object clientdata, /* Pointer to sqlite3_enable_XXX function */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      sqlite3_test_control( SQLITE_TESTCTRL_PRNG_RESET );
      return TCL.TCL_OK;
    }


    /*
    ** tclcmd: pcache_stats
    */
    static int test_pcache_stats(
    ClientData clientData, /* Pointer to sqlite3_enable_XXX function */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      int nMin;
      int nMax;
      int nCurrent;
      int nRecyclable;
      Tcl_Obj pRet;

      sqlite3PcacheStats( out nCurrent, out nMax, out nMin, out nRecyclable );

      pRet = TCL.Tcl_NewObj();
      TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewStringObj( "current", -1 ) );
      TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewIntObj( nCurrent ) );
      TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewStringObj( "max", -1 ) );
      TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewIntObj( nMax ) );
      TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewStringObj( "min", -1 ) );
      TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewIntObj( nMin ) );
      TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewStringObj( "recyclable", -1 ) );
      TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewIntObj( nRecyclable ) );

      TCL.Tcl_SetObjResult( interp, pRet );

      return TCL.TCL_OK;
    }



    public class _aObjCmd
    {
      public string zName;
      public Interp.dxObjCmdProc xProc;
      public object clientData;
      public _aObjCmd( string zName, Interp.dxObjCmdProc xProc )
      {
        this.zName = zName;
        this.xProc = xProc;
        this.clientData = null;
      }
      public _aObjCmd( string zName, Interp.dxObjCmdProc xProc, object clientdata )
      {
        this.zName = zName;
        this.xProc = xProc;
        this.clientData = clientdata.GetType().Name == "Int32" && (int)clientdata == 0 ? null : clientdata;
      }
    }

#if SQLITE_ENABLE_UNLOCK_NOTIFY
static void test_unlock_notify_cb(void **aArg, int nArg){
int ii;
for(ii=0; ii<nArg; ii++){
TCL.Tcl_EvalEx((Tcl_Interp )aArg[ii], "unlock_notify", -1, TCL.TCL_EVAL_GLOBAL);
}
}
#endif //* SQLITE_ENABLE_UNLOCK_NOTIFY */

    /*
** tclcmd: sqlite3_unlock_notify db
*/
#if SQLITE_ENABLE_UNLOCK_NOTIFY
static int test_unlock_notify(
ClientData clientData, /* Unused */
Tcl_Interp interp, /* The TCL interpreter that invoked this command */
int objc, /* Number of arguments */
Tcl_Obj[] objv /* Command arguments */
){
sqlite3 db;
int rc;

if( objc!=2 ){
TCL.Tcl_WrongNumArgs(interp, 1, objv, "DB");
return TCL.TCL_ERROR;
}

if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), &db) ){
return TCL.TCL_ERROR;
}
rc = sqlite3_unlock_notify(db, test_unlock_notify_cb, (void )interp);
TCL.Tcl_SetResult(interp, (char )t1ErrorName(rc), TCL.TCL_STATIC);
return TCL.TCL_OK;
}
#endif

    /*
** tclcmd: sqlite3_wal_checkpoint db ?NAME?
*/
    static int test_wal_checkpoint(
    ClientData clientData, /* Unused */
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      string zDb = "";
      sqlite3 db = null;
      int rc;

      if ( objc != 3 && objc != 2 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB ?NAME?" );
        return TCL.TCL_ERROR;
      }

      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
      {
        return TCL.TCL_ERROR;
      }
      if ( objc == 3 )
      {
        zDb = TCL.Tcl_GetString( objv[2] );
      }
      rc = sqlite3_wal_checkpoint( db, zDb );
      TCL.Tcl_SetResult( interp, t1ErrorName( rc ), TCL.TCL_STATIC );
      return TCL.TCL_OK;
    }

    /*
** tclcmd:  sqlite3_wal_checkpoint_v2 db MODE ?NAME?
**
** This command calls the wal_checkpoint_v2() function with the specified
** mode argument (passive, full or restart). If present, the database name
** NAME is passed as the second argument to wal_checkpoint_v2(). If it the
** NAME argument is not present, a NULL pointer is passed instead.
**
** If wal_checkpoint_v2() returns any value other than SQLITE_BUSY or
** SQLITE_OK, then this command returns TCL_ERROR. The Tcl result is set
** to the error message obtained from sqlite3_errmsg().
**
** Otherwise, this command returns a list of three integers. The first integer
** is 1 if SQLITE_BUSY was returned, or 0 otherwise. The following two integers
** are the values returned via the output paramaters by wal_checkpoint_v2() -
** the number of frames in the log and the number of frames in the log
** that have been checkpointed.
*/
    static int test_wal_checkpoint_v2(
        ClientData clientData, /* Pointer to sqlite3_enable_XXX function */
        Tcl_Interp interp, /* The TCL interpreter that invoked this command */
        int objc, /* Number of arguments */
        Tcl_Obj[] objv /* Command arguments */
    )
    {
      string zDb = "";
      sqlite3 db = null;
      int rc;

      int eMode = 0;
      int nLog = -555;
      int nCkpt = -555;
      Tcl_Obj pRet;

      string[] aMode = new string[] { "passive", "full", "restart" };
      Debug.Assert( SQLITE_CHECKPOINT_PASSIVE == 0 );
      Debug.Assert( SQLITE_CHECKPOINT_FULL == 1 );
      Debug.Assert( SQLITE_CHECKPOINT_RESTART == 2 );

      if ( objc != 3 && objc != 4 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB MODE ?NAME?" );
        return TCL.TCL_ERROR;
      }

      if ( objc == 4 )
      {
        zDb = TCL.Tcl_GetString( objv[3] );
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0
       || TCL.Tcl_GetIndexFromObj( interp, objv[2], aMode, "mode", 0, out eMode )
      )
      {
        return TCL.TCL_ERROR;
      }

      rc = sqlite3_wal_checkpoint_v2( db, zDb, eMode, out nLog, out nCkpt );
      if ( rc != SQLITE_OK && rc != SQLITE_BUSY )
      {
        TCL.Tcl_SetResult( interp, sqlite3_errmsg( db ), TCL.TCL_VOLATILE );
        return TCL.TCL_ERROR;
      }

      pRet = TCL.Tcl_NewObj();
      TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewIntObj( rc == SQLITE_BUSY ? 1 : 0 ) );
      TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewIntObj( nLog ) );
      TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewIntObj( nCkpt ) );
      TCL.Tcl_SetObjResult( interp, pRet );

      return TCL.TCL_OK;
    }

    /*
    ** tclcmd: test_sqlite3_log ?SCRIPT?
    */
    struct LogCallback
    {
      public Tcl_Interp pInterp;
      public Tcl_Obj pObj;
    }
    static LogCallback logcallback = new LogCallback();

    static void xLogcallback( object unused, int err, string zMsg )
    {
      Tcl_Obj pNew = TCL.Tcl_DuplicateObj( logcallback.pObj );
      TCL.Tcl_IncrRefCount( pNew );
      TCL.Tcl_ListObjAppendElement(
      null, pNew, TCL.Tcl_NewStringObj( sqlite3TestErrorName( err ), -1 )
      );
      TCL.Tcl_ListObjAppendElement( null, pNew, TCL.Tcl_NewStringObj( zMsg, -1 ) );
      TCL.Tcl_EvalObjEx( logcallback.pInterp, pNew, TCL.TCL_EVAL_GLOBAL | TCL.TCL_EVAL_DIRECT );
      TCL.Tcl_DecrRefCount( ref pNew );
    }

    static int test_sqlite3_log(
    ClientData clientData,
    Tcl_Interp interp, /* The TCL interpreter that invoked this command */
    int objc, /* Number of arguments */
    Tcl_Obj[] objv /* Command arguments */
    )
    {
      if ( objc > 2 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "SCRIPT" );
        return TCL.TCL_ERROR;
      }
      if ( logcallback.pObj != null )
      {
        TCL.Tcl_DecrRefCount( ref logcallback.pObj );
        logcallback.pObj = null;
        logcallback.pInterp = null;
        sqlite3_config( SQLITE_CONFIG_LOG, 0, 0 );
      }
      if ( objc > 1 )
      {
        logcallback.pObj = objv[1];
        TCL.Tcl_IncrRefCount( logcallback.pObj );
        logcallback.pInterp = interp;
        sqlite3_config( SQLITE_CONFIG_LOG, (dxLogcallback)xLogcallback, 0 );
      }
      return TCL.TCL_OK;
    }


    /*
    ** tcl_objproc COMMANDNAME ARGS...
    **
    ** Run a TCL command using its objProc interface. Throw an error if
    ** the command has no objProc interface.
    */
    //static int runAsObjProc(
    // void * clientData,
    // Tcl_Interp interp,
    // int objc,
    // Tcl_Obj[] objv
    //){
    // TCL.Tcl_CmdInfo cmdInfo;
    // if( objc<2 ){
    // TCL.Tcl_WrongNumArgs(interp, 1, objv, "COMMAND ...");
    // return TCL.TCL_ERROR;
    // }
    // if( null==TCL.Tcl_GetCommandInfo(interp, TCL.Tcl_GetString(objv[1]), &cmdInfo) ){
    // TCL.Tcl_AppendResult(interp, "command not found: ",
    // TCL.Tcl_GetString(objv[1]), (char)0);
    // return TCL.TCL_ERROR;
    // }
    // if( cmdInfo.objProc==0 ){
    // TCL.Tcl_AppendResult(interp, "command has no objProc: ",
    // TCL.Tcl_GetString(objv[1]), (char)0);
    // return TCL.TCL_ERROR;
    // }
    // return cmdInfo.objProc(cmdInfo.objClientData, interp, objc-1, objv+1);
    //}

    /*
    ** Register commands with the TCL interpreter.
    */

#if !SQLITE_OMIT_EXPLAIN
    /*
** WARNING: The following function, printExplainQueryPlan() is an exact
** copy of example code from eqp.in (eqp.html). If this code is modified,
** then the documentation copy needs to be modified as well.
*/
    /*
    ** Argument pStmt is a prepared SQL statement. This function compiles
    ** an EXPLAIN QUERY PLAN command to report on the prepared statement,
    ** and prints the report to stdout using printf().
    */
    static int printExplainQueryPlan( sqlite3_stmt pStmt )
    {
      string zSql; /* Input SQL */
      string zExplain; /* SQL with EXPLAIN QUERY PLAN prepended */
      sqlite3_stmt pExplain = null; /* Compiled EXPLAIN QUERY PLAN command */
      int rc; /* Return code from sqlite3_prepare_v2() */

      zSql = sqlite3_sql( pStmt );
      if ( zSql == null )
        return SQLITE_ERROR;

      zExplain = sqlite3_mprintf( "EXPLAIN QUERY PLAN %s", zSql );
      //if ( zExplain == null )
      //  return SQLITE_NOMEM;

      rc = sqlite3_prepare_v2( sqlite3_db_handle( pStmt ), zExplain, -1, ref pExplain, 0 );
      //sqlite3_free(zExplain);
      if ( rc != SQLITE_OK )
        return rc;

      while ( SQLITE_ROW == sqlite3_step( pExplain ) )
      {
        int iSelectid = sqlite3_column_int( pExplain, 0 );
        int iOrder = sqlite3_column_int( pExplain, 1 );
        int iFrom = sqlite3_column_int( pExplain, 2 );
        string zDetail = sqlite3_column_text( pExplain, 3 );

        printf( "%d %d %d %s\n", iSelectid, iOrder, iFrom, zDetail );
      }

      return sqlite3_finalize( pExplain );
    }

    static int test_print_eqp(
    object clientData,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      int rc;
      sqlite3_stmt pStmt = null;

      if ( objc != 2 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "STMT" );
        return TCL.TCL_ERROR;
      }
      if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
        return TCL.TCL_ERROR;
      rc = printExplainQueryPlan( pStmt );
      /* This is needed on Windows so that a test case using this 
      ** function can open a read pipe and get the output of
      ** printExplainQueryPlan() immediately.
      */
      //fflush( stdout );
      TCL.Tcl_SetResult( interp, t1ErrorName( rc ), 0 );
      return TCL.TCL_OK;
    }
#endif //* SQLITE_OMIT_EXPLAIN */

    class Verb
    {
      public string zName;
      public int i;

      public Verb( string zName, int i )
      {
        this.zName = zName;
        this.i = i;
      }
    }

    /*
** sqlite3_test_control VERB ARGS...
*/
    static int test_test_control(
        object clientData,
        Tcl_Interp interp,
        int objc,
        Tcl_Obj[] objv
    )
    {
      Verb[] aVerb = new Verb[] {
    new Verb( "SQLITE_TESTCTRL_LOCALTIME_FAULT", SQLITE_TESTCTRL_LOCALTIME_FAULT ), 
  };
      int iVerb;
      int iFlag;
      int rc;

      if ( objc < 2 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "VERB ARGS..." );
        return TCL.TCL_ERROR;
      }

      //rc = TCL.Tcl_GetIndexFromObjStruct(
      //    interp, objv[1], aVerb, sizeof(aVerb[0]), "VERB", 0, &iVerb
      //);
      for ( iVerb = 0; iVerb < aVerb.Length && ( aVerb[iVerb].zName != objv[1].ToString() ); iVerb++ )
      {
      }
      if ( iVerb >= aVerb.Length )
        return TCL.TCL_ERROR;

      iFlag = aVerb[iVerb].i;
      switch ( iFlag )
      {
        case SQLITE_TESTCTRL_LOCALTIME_FAULT:
          {
            bool val = false;
            if ( objc != 3 )
            {
              TCL.Tcl_WrongNumArgs( interp, 2, objv, "ONOFF" );
              return TCL.TCL_ERROR;
            }
            if ( TCL.Tcl_GetBooleanFromObj( interp, objv[2], out val ) )
              return TCL.TCL_ERROR;
            sqlite3_test_control( SQLITE_TESTCTRL_LOCALTIME_FAULT, val );
            break;
          }
      }

      TCL.Tcl_ResetResult( interp );
      return TCL.TCL_OK;
    }

    /*
    ** optimization_control DB OPT BOOLEAN
    **
    ** Enable or disable query optimizations using the sqlite3_test_control()
    ** interface. Disable if BOOLEAN is false and enable if BOOLEAN is true.
    ** OPT is the name of the optimization to be disabled.
    */
    public class _aOpt
    {
      public string zOptName;
      public int mask;

      public _aOpt( string zOptName, int mask )
      {
        this.zOptName = zOptName;
        this.mask = mask;
      }
    }

    static int optimization_control(
    object clientData,
    Tcl_Interp interp,
    int objc,
    Tcl_Obj[] objv
    )
    {
      int i;
      sqlite3 db = null;
      string zOpt;
      bool onoff = false;
      int mask = 0;
      _aOpt[] aOpt = {
new _aOpt( "all", SQLITE_OptMask ),
new _aOpt( "query-flattener", SQLITE_QueryFlattener ),
new _aOpt( "column-cache", SQLITE_ColumnCache ),
new _aOpt( "index-sort", SQLITE_IndexSort ),
new _aOpt( "index-search", SQLITE_IndexSearch ),
new _aOpt( "index-cover", SQLITE_IndexCover ),
new _aOpt( "groupby-order", SQLITE_GroupByOrder ),
new _aOpt( "factor-constants", SQLITE_FactorOutConst ),
new _aOpt( "real-as-int", SQLITE_IdxRealAsInt   ),
};

      if ( objc != 4 )
      {
        TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB OPT BOOLEAN" );
        return TCL.TCL_ERROR;
      }
      if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
        return TCL.TCL_ERROR;
      if ( TCL.Tcl_GetBooleanFromObj( interp, objv[3], out onoff ) )
        return TCL.TCL_ERROR;
      zOpt = TCL.Tcl_GetString( objv[2] );
      for ( i = 0; i < aOpt.Length; i++ )//sizeof(aOpt)/sizeof(aOpt[0]); i++)
      {
        if ( zOpt == aOpt[i].zOptName )
        {
          mask = aOpt[i].mask;
          break;
        }
      }
      if ( onoff )
        mask = ~mask;
      if ( i >= aOpt.Length )//sizeof(aOpt)/sizeof(aOpt[0]) )
      {
        TCL.Tcl_AppendResult( interp, "unknown optimization - should be one of:",
        null );
        for ( i = 0; i < aOpt.Length; i++ )//sizeof(aOpt)/sizeof(aOpt[0]); i++)
        {
          TCL.Tcl_AppendResult( interp, " ", aOpt[i].zOptName );
        }
        return TCL.TCL_ERROR;
      }
      sqlite3_test_control( SQLITE_TESTCTRL_OPTIMIZATIONS, db, mask );
      return TCL.TCL_OK;
    }


    static Var.SQLITE3_GETSET bitmask_size = new Var.SQLITE3_GETSET( "bitmask_size" );

#if SQLITE_OS_UNIX && (__APPLE__) && SQLITE_ENABLE_LOCKING_STYLE
extern int sqlite3_hostid_num;
#endif
    static Var.SQLITE3_GETSET sqlite_static_bind_nbyte = new Var.SQLITE3_GETSET( "static_bind_nbyte" );
    static Var.SQLITE3_GETSET sqlite_static_bind_value = new Var.SQLITE3_GETSET( "static_bind_value" );

    public static int Sqlitetest1_Init( Tcl_Interp interp )
    {
      // extern int sqlite3_search_count;
      // extern int sqlite3_found_count;
      // extern int sqlite3_interrupt_count;
      // extern int sqlite3_sort_count;
      // extern int sqlite3_current_time;
      // extern int sqlite3_max_blobsize;
      // extern int sqlite3BtreeSharedCacheReport(void*,
      // Tcl_Interp *,int,Tcl_Obj*CONST);
      // static struct {
      // string zName;
      // TCL.Tcl_CmdProc *xProc;
      _aCmd[] aCmd = new _aCmd[] {
new _aCmd( "db_enter", db_enter ),
new _aCmd( "db_leave", db_leave ),
new _aCmd( "sqlite3_mprintf_int", sqlite3_mprintf_int ),
new _aCmd( "sqlite3_mprintf_int64", sqlite3_mprintf_int64 ),
new _aCmd( "sqlite3_mprintf_long", sqlite3_mprintf_long ),
new _aCmd( "sqlite3_mprintf_str", sqlite3_mprintf_str ),
new _aCmd( "sqlite3_snprintf_str", sqlite3_snprintf_str ),
new _aCmd( "sqlite3_mprintf_stronly", sqlite3_mprintf_stronly),
new _aCmd( "sqlite3_mprintf_double", sqlite3_mprintf_double ),
new _aCmd( "sqlite3_mprintf_scaled", sqlite3_mprintf_scaled ),
new _aCmd( "sqlite3_mprintf_hexdouble", sqlite3_mprintf_hexdouble),
new _aCmd( "sqlite3_mprintf_z_test", test_mprintf_z ),
new _aCmd( "sqlite3_mprintf_n_test", test_mprintf_n ),
new _aCmd( "sqlite3_snprintf_int", test_snprintf_int ),
// new _aCmd( "sqlite3_last_insert_rowid", test_last_rowid ),
new _aCmd( "sqlite3_exec_printf", test_exec_printf ),
new _aCmd( "sqlite3_exec_hex", test_exec_hex ),
new _aCmd( "sqlite3_exec", test_exec ),
new _aCmd( "sqlite3_exec_nr", test_exec_nr ),
#if !SQLITE_OMIT_GET_TABLE
new _aCmd( "sqlite3_get_table_printf", test_get_table_printf ),
#endif
new _aCmd( "sqlite3_close", sqlite_test_close ),
new _aCmd( "sqlite3_create_function", test_create_function ),
new _aCmd( "sqlite3_create_aggregate", test_create_aggregate ),
new _aCmd( "sqlite_register_test_function", test_register_func ),
// new _aCmd( "sqlite_abort", sqlite_abort ),
new _aCmd( "sqlite_bind", test_bind ),
new _aCmd( "breakpoint", test_breakpoint ),
new _aCmd( "sqlite3_key", test_key ),
new _aCmd( "sqlite3_rekey", test_rekey ),
new _aCmd( "sqlite_set_magic", sqlite_set_magic ),
new _aCmd( "sqlite3_interrupt", test_interrupt ),
new _aCmd( "sqlite_delete_function", delete_function ),
new _aCmd( "sqlite_delete_collation", delete_collation ),
new _aCmd( "sqlite3_get_autocommit", get_autocommit ),
// new _aCmd( "sqlite3_stack_used", test_stack_used ),
new _aCmd( "sqlite3_busy_timeout", test_busy_timeout ),
// new _aCmd( "printf", test_printf ),
// new _aCmd( "sqlite3IoTrace", test_io_trace ),
};
      // static struct {
      // string zName;
      // Tcl_ObjCmdProc *xProc;
      // void *object;
      _aObjCmd[] aObjCmd = new _aObjCmd[]{
new _aObjCmd( "sqlite3_connection_pointer", get_sqlite_pointer, 0 ),
new _aObjCmd( "sqlite3_bind_int", test_bind_int, 0 ),
new _aObjCmd( "sqlite3_bind_zeroblob", test_bind_zeroblob, 0 ),
new _aObjCmd( "sqlite3_bind_int64", test_bind_int64, 0 ),
new _aObjCmd( "sqlite3_bind_double", test_bind_double, 0 ),
new _aObjCmd( "sqlite3_bind_null", test_bind_null ,0 ),
new _aObjCmd( "sqlite3_bind_text", test_bind_text ,0 ),
new _aObjCmd( "sqlite3_bind_text16", test_bind_text16 ,0 ),
new _aObjCmd( "sqlite3_bind_blob", test_bind_blob ,0 ),
new _aObjCmd( "sqlite3_bind_parameter_count", test_bind_parameter_count, 0),
new _aObjCmd( "sqlite3_bind_parameter_name", test_bind_parameter_name, 0),
new _aObjCmd( "sqlite3_bind_parameter_index", test_bind_parameter_index, 0),
new _aObjCmd( "sqlite3_clear_bindings", test_clear_bindings, 0),
new _aObjCmd( "sqlite3_sleep", test_sleep, 0),
new _aObjCmd( "sqlite3_errcode", test_errcode ,0 ),
new _aObjCmd( "sqlite3_extended_errcode", test_ex_errcode ,0 ),
new _aObjCmd( "sqlite3_errmsg", test_errmsg ,0 ),
// new _aObjCmd( "sqlite3_errmsg16", test_errmsg16 ,0 ),
new _aObjCmd( "sqlite3_open", test_open ,0 ),
// new _aObjCmd( "sqlite3_open16", test_open16 ,0 ),
new _aObjCmd( "sqlite3_open_v2", test_open_v2 ,0 ),
// new _aObjCmd( "sqlite3_complete16", test_complete16 ,0 ),

new _aObjCmd( "sqlite3_prepare", test_prepare ,0 ),
new _aObjCmd( "sqlite3_prepare16", test_prepare16 ,0 ),
new _aObjCmd( "sqlite3_prepare_v2", test_prepare_v2 ,0 ),
new _aObjCmd( "sqlite3_prepare_tkt3134", test_prepare_tkt3134, 0),
// new _aObjCmd( "sqlite3_prepare16_v2", test_prepare16_v2 ,0 ),
new _aObjCmd( "sqlite3_finalize", test_finalize ,0 ),
new _aObjCmd( "sqlite3_reset", test_reset ,0 ),
new _aObjCmd( "sqlite3_expired", test_expired ,0 ),
new _aObjCmd( "sqlite3_transfer_bindings", test_transfer_bind ,0 ),
new _aObjCmd( "sqlite3_changes", test_changes ,0 ),
new _aObjCmd( "sqlite3_step", test_step ,0 ),
// { "sqlite3_sql", test_sql ,0 },
new _aObjCmd( "sqlite3_next_stmt", test_next_stmt ,0 ),
new _aObjCmd( "sqlite3_stmt_readonly", test_stmt_readonly ,0 ),
new _aObjCmd( "uses_stmt_journal",  uses_stmt_journal ,0 ),

new _aObjCmd( "sqlite3_release_memory", test_release_memory, 0),
new _aObjCmd( "sqlite3_soft_heap_limit", test_soft_heap_limit, 0),
// new _aObjCmd( "sqlite3_thread_cleanup", test_thread_cleanup, 0),
// new _aObjCmd( "sqlite3_pager_refcounts", test_pager_refcounts, 0),

// new _aObjCmd( "sqlite3_load_extension", test_load_extension, 0),
// new _aObjCmd( "sqlite3_enable_load_extension", test_enable_load, 0),
new _aObjCmd( "sqlite3_extended_result_codes", test_extended_result_codes, 0),
new _aObjCmd( "sqlite3_limit", test_limit, 0),

new _aObjCmd( "save_prng_state", save_prng_state, 0 ),
new _aObjCmd( "restore_prng_state", restore_prng_state, 0 ),
new _aObjCmd( "reset_prng_state", reset_prng_state, 0 ),
new _aObjCmd( "optimization_control", optimization_control,0),
// { "tcl_objproc", runAsObjProc, 0 },

// /* sqlite3_column_*() API */
new _aObjCmd( "sqlite3_column_count", test_column_count ,0 ),
new _aObjCmd( "sqlite3_data_count", test_data_count ,0 ),
new _aObjCmd( "sqlite3_column_type", test_column_type ,0 ),
new _aObjCmd( "sqlite3_column_blob", test_column_blob ,0 ),
new _aObjCmd( "sqlite3_column_double", test_column_double ,0 ),
new _aObjCmd( "sqlite3_column_int64", test_column_int64 ,0 ),
new _aObjCmd( "sqlite3_column_text", test_stmt_utf8, (dxColumn)sqlite3_column_text ),
new _aObjCmd( "sqlite3_column_name", test_stmt_utf8, (dxColumn)sqlite3_column_name ),
new _aObjCmd( "sqlite3_column_int", test_stmt_int, (dxColumn_I)sqlite3_column_int ),
new _aObjCmd( "sqlite3_column_bytes", test_stmt_int, (dxColumn_I)sqlite3_column_bytes ),
#if !SQLITE_OMIT_DECLTYPE
new _aObjCmd( "sqlite3_column_decltype", test_stmt_utf8, (dxColumn) sqlite3_column_decltype ),
#endif
#if SQLITE_ENABLE_COLUMN_METADATA
new _aObjCmd( "sqlite3_column_database_name", test_stmt_utf8, (dxColumn)sqlite3_column_database_name),
new _aObjCmd( "sqlite3_column_table_name", test_stmt_utf8, (dxColumn)sqlite3_column_table_name),
new _aObjCmd( "sqlite3_column_origin_name", test_stmt_utf8, (dxColumn)sqlite3_column_origin_name),
#endif

#if !SQLITE_OMIT_UTF16
// { "sqlite3_column_bytes16", test_stmt_int, sqlite3_column_bytes16 ),
// { "sqlite3_column_text16", test_stmt_utf16, sqlite3_column_text16 ),
// { "sqlite3_column_decltype16", test_stmt_utf16, sqlite3_column_decltype16),
// { "sqlite3_column_name16", test_stmt_utf16, sqlite3_column_name16 ),
// { "add_alignment_test_collations", add_alignment_test_collations, 0 ),
#if SQLITE_ENABLE_COLUMN_METADATA
//{"sqlite3_column_database_name16",
// test_stmt_utf16, sqlite3_column_database_name16),
//{"sqlite3_column_table_name16", test_stmt_utf16, sqlite3_column_table_name16),
//{"sqlite3_column_origin_name16", test_stmt_utf16, sqlite3_column_origin_name16),
#endif
#endif
new _aObjCmd( "sqlite3_create_collation_v2", test_create_collation_v2, 0 ),
new _aObjCmd( "sqlite3_global_recover", test_global_recover, 0 ),
new _aObjCmd( "working_64bit_int", working_64bit_int, 0 ),
new _aObjCmd( "vfs_unlink_test", vfs_unlink_test, 0 ),
//{ "vfs_initfail_test", vfs_initfail_test, 0 },
new _aObjCmd( "vfs_unregister_all", vfs_unregister_all, 0 ),
new _aObjCmd("vfs_reregister_all", vfs_reregister_all, 0 ),
new _aObjCmd( "file_control_test", file_control_test, 0 ),
new _aObjCmd("file_control_lasterrno_test", file_control_lasterrno_test, 0 ),
new _aObjCmd("file_control_lockproxy_test", file_control_lockproxy_test, 0 ),
new _aObjCmd("file_control_chunksize_test", file_control_chunksize_test, 0 ),
new _aObjCmd("file_control_sizehint_test", file_control_sizehint_test,  0),
//new _aObjCmd( "sqlite3_vfs_list", vfs_list, 0 ),
new _aObjCmd( "sqlite3_create_function_v2", test_create_function_v2, 0 ),

// /* Functions from os.h */
#if !SQLITE_OMIT_UTF16
// { "add_test_collate", test_collate, 0 ),
// { "add_test_collate_needed", test_collate_needed, 0 ),
// { "add_test_function", test_function, 0 ),
#endif
new _aObjCmd( "sqlite3_test_errstr", test_errstr, 0 ),
new _aObjCmd( "tcl_variable_type", tcl_variable_type, 0 ),
#if !SQLITE_OMIT_SHARED_CACHE
new _aObjCmd( "sqlite3_enable_shared_cache", test_enable_shared, 0 ),
//{ "sqlite3_shared_cache_report", sqlite3BtreeSharedCacheReport, 0),
#endif
 new _aObjCmd( "sqlite3_libversion_number", test_libversion_number, 0 ),
#if SQLITE_ENABLE_COLUMN_METADATA
 new _aObjCmd( "sqlite3_table_column_metadata", test_table_column_metadata, 0 ),
#endif
#if !SQLITE_OMIT_INCRBLOB
// new _aObjCmd( "sqlite3_blob_read", test_blob_read, 0 ),
// new _aObjCmd( "sqlite3_blob_write", test_blob_write, 0 ),
//{ "sqlite3_blob_reopen", test_blob_reopen, 0 },
//{ "sqlite3_blob_bytes", test_blob_bytes, 0 },
//{ "sqlite3_blob_close", test_blob_close, 0 },
#endif
new _aObjCmd( "pcache_stats", test_pcache_stats, 0 ),
#if SQLITE_ENABLE_UNLOCK_NOTIFY
{ "sqlite3_unlock_notify", test_unlock_notify, 0 },
#endif
new _aObjCmd( "sqlite3_wal_checkpoint", test_wal_checkpoint, 0 ),
new _aObjCmd( "sqlite3_wal_checkpoint_v2", test_wal_checkpoint_v2, 0 ),
new _aObjCmd( "test_sqlite3_log", test_sqlite3_log, 0 ),
#if !SQLITE_OMIT_EXPLAIN
new _aObjCmd( "print_explain_query_plan", test_print_eqp, 0 ),
#endif
new _aObjCmd( "sqlite3_test_control", test_test_control ),
      };
      bitmask_size.iValue = BMS;
      int i;
      // extern int sqlite3_sync_count, sqlite3_fullsync_count;
      // extern int sqlite3_opentemp_count;
      // extern int sqlite3_like_count;
      // extern int sqlite3_xferopt_count;
      // extern int sqlite3_pager_readdb_count;
      // extern int sqlite3_pager_writedb_count;
      // extern int sqlite3_pager_writej_count;
#if SQLITE_OS_WIN
      // extern int sqlite3_os_type;
#endif
#if SQLITE_DEBUG
      // extern int sqlite3WhereTrace;
      // extern int sqlite3OSTrace;
      // extern int sqlite3VdbeAddopTrace;
      // extern int sqlite3WalTrace;
#endif
#if SQLITE_TEST
      // extern char sqlite3_query_plan[];
      // static char *query_plan = sqlite3_query_plan;
#if SQLITE_ENABLE_FTS3
extern int sqlite3_fts3_enable_parentheses;
#endif
#endif

      for ( i = 0; i < aCmd.Length; i++ )
      {//sizeof(aCmd)/sizeof(aCmd[0]); i++){
        TCL.Tcl_CreateCommand( interp, aCmd[i].zName, aCmd[i].xProc, null, null );
      }
      for ( i = 0; i < aObjCmd.Length; i++ )
      {// i<sizeof(aObjCmd)/sizeof(aObjCmd[0]); i++){
        TCL.Tcl_CreateObjCommand( interp, aObjCmd[i].zName,
        (Interp.dxObjCmdProc)aObjCmd[i].xProc, (object)aObjCmd[i].clientData, null );
      }
      TCL.Tcl_LinkVar( interp, "sqlite_search_count",
      sqlite3_search_count, VarFlags.SQLITE3_LINK_INT );
      TCL.Tcl_LinkVar( interp, "sqlite_found_count",
      sqlite3_found_count, VarFlags.SQLITE3_LINK_INT );
      TCL.Tcl_LinkVar( interp, "sqlite_sort_count",
      sqlite3_sort_count, VarFlags.SQLITE3_LINK_INT );
      TCL.Tcl_LinkVar( interp, "sqlite3_max_blobsize",
      sqlite3_max_blobsize, VarFlags.SQLITE3_LINK_INT );
      TCL.Tcl_LinkVar( interp, "sqlite_like_count",
      sqlite3_like_count, VarFlags.SQLITE3_LINK_INT );
      TCL.Tcl_LinkVar( interp, "sqlite_interrupt_count",
      sqlite3_interrupt_count, VarFlags.SQLITE3_LINK_INT );
      TCL.Tcl_LinkVar( interp, "sqlite_open_file_count",
      sqlite3_open_file_count, VarFlags.SQLITE3_LINK_INT );
      TCL.Tcl_LinkVar( interp, "sqlite_current_time",
      sqlite3_current_time, VarFlags.SQLITE3_LINK_INT );
#if SQLITE_OS_UNIX && (__APPLE__) && SQLITE_ENABLE_LOCKING_STYLE
TCL.Tcl_LinkVar(interp, "sqlite_hostid_num",
(char)&sqlite3_hostid_num, TCL.Tcl_LINK_INT);
#endif
      TCL.Tcl_LinkVar( interp, "sqlite3_xferopt_count",
      sqlite3_xferopt_count, VarFlags.SQLITE3_LINK_INT );
      TCL.Tcl_LinkVar( interp, "sqlite3_pager_readdb_count",
      sqlite3_pager_readdb_count, VarFlags.SQLITE3_LINK_INT );
      TCL.Tcl_LinkVar( interp, "sqlite3_pager_writedb_count",
      sqlite3_pager_writedb_count, VarFlags.SQLITE3_LINK_INT );
      TCL.Tcl_LinkVar( interp, "sqlite3_pager_writej_count",
      sqlite3_pager_writej_count, VarFlags.SQLITE3_LINK_INT );
#if !SQLITE_OMIT_UTF16
// TCL.Tcl_LinkVar(interp, "unaligned_string_counter",
// (char)&unaligned_string_counter, VarFlag.SQLITE3_LINK_INT);
#endif
#if !SQLITE_OMIT_UTF16
// TCL.Tcl_LinkVar(interp, "sqlite_last_needed_collation",
// (char)&pzNeededCollation, VarFlag.TCL_LINK_STRING|VarFlag.TCL_LINK_READ_ONLY);
#endif
#if SQLITE_OS_WIN
      // TCL.Tcl_LinkVar(interp, "sqlite_os_type",
      // (char)&sqlite3_os_type, VarFlag.SQLITE3_LINK_INT);
#endif
#if SQLITE_TEST
      TCL.Tcl_LinkVar( interp, "sqlite_query_plan",
      sqlite3_query_plan, VarFlags.SQLITE3_LINK_STRING | VarFlags.SQLITE3_LINK_READ_ONLY );
#endif
#if SQLITE_DEBUG
      // TCL.Tcl_LinkVar(interp, "sqlite_addop_trace",
      // (char)&sqlite3VdbeAddopTrace, VarFlag.SQLITE3_LINK_INT);
      // TCL.Tcl_LinkVar(interp, "sqlite_where_trace",
      // (char)&sqlite3WhereTrace, VarFlag.SQLITE3_LINK_INT);
      // TCL.Tcl_LinkVar(interp, "sqlite_os_trace",
      // (char)&sqlite3OSTrace, VarFlag.SQLITE3_LINK_INT);
#if !SQLITE_OMIT_WAL
TCL.Tcl_LinkVar((interp, "sqlite_wal_trace",
(char)&sqlite3WalTrace, VarFlag.SQLITE3_LINK_INT);
#endif
#endif
#if !SQLITE_OMIT_DISKIO
      TCL.Tcl_LinkVar( interp, "sqlite_opentemp_count",
      sqlite3_opentemp_count, VarFlags.SQLITE3_LINK_INT );
#endif
      TCL.Tcl_LinkVar( interp, "sqlite_static_bind_value",
      sqlite_static_bind_value, VarFlags.SQLITE3_LINK_STRING );
      TCL.Tcl_LinkVar( interp, "sqlite_static_bind_nbyte",
      sqlite_static_bind_nbyte, VarFlags.SQLITE3_LINK_INT );
      // TCL.Tcl_LinkVar(interp, "sqlite_temp_directory",
      // (char)&sqlite3_temp_directory, VarFlag.TCL_LINK_STRING);
      TCL.Tcl_LinkVar( interp, "bitmask_size",
      bitmask_size, VarFlags.SQLITE3_LINK_INT | VarFlags.SQLITE3_LINK_READ_ONLY );
      TCL.Tcl_LinkVar( interp, "sqlite_sync_count",
      sqlite3_sync_count, VarFlags.SQLITE3_LINK_INT );
      TCL.Tcl_LinkVar( interp, "sqlite_fullsync_count",
      sqlite3_fullsync_count, VarFlags.SQLITE3_LINK_INT );
#if (SQLITE_ENABLE_FTS3) && (SQLITE_TEST)
TCL.Tcl_LinkVar(interp, "sqlite_fts3_enable_parentheses",
(char)&sqlite3_fts3_enable_parentheses, TCL.Tcl_LINK_INT);
#endif
      return TCL.TCL_OK;
    }
  }
#endif
}
